If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Leap Day - February 29
I have a DOB field in a table, data type Date/Time, format mm/dd - I am not
storing the year, it is unimportant in my project. The problem is that we have a few records with a DOB of 2/29, Leap Day. Every time we enter this, Access changes it to 2/01, which is incorrect. I've looked at the Technet/KB section for Access, but cannot find this problem addressed anywhere. I would greatly appreciate anyone who could tell me a way to get around this -- an easy way to get around this. |
#2
|
|||
|
|||
When you enter the date 2/29, since this is 2005 is not a leap year, Access
assumes you mean the second month of 2029 and displays the first day of February 2029. Try entering 2/29/2004 (2004 was a leap year) and you'll see that it works, or it should. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Anita Taylor" Anita wrote in message ... I have a DOB field in a table, data type Date/Time, format mm/dd - I am not storing the year, it is unimportant in my project. The problem is that we have a few records with a DOB of 2/29, Leap Day. Every time we enter this, Access changes it to 2/01, which is incorrect. I've looked at the Technet/KB section for Access, but cannot find this problem addressed anywhere. I would greatly appreciate anyone who could tell me a way to get around this -- an easy way to get around this. |
#3
|
|||
|
|||
Try entering 2/29/2004 (2004 was a leap year)
That works fine. We dummy all birth years to be the current year, which in this case is 2005, but the logic of our reports depends on the birth day being less than our selected date, so this should still work. I appreciate the tip. |
#4
|
|||
|
|||
I'm glad it works for you.
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Anita Taylor" wrote in message ... Try entering 2/29/2004 (2004 was a leap year) That works fine. We dummy all birth years to be the current year, which in this case is 2005, but the logic of our reports depends on the birth day being less than our selected date, so this should still work. I appreciate the tip. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Join 2 Tables with query problem | ShyGuy | Running & Setting Up Queries | 3 | October 14th, 2004 04:24 AM |
code to correct leap yr problem in February 2004 | ron | General Discussion | 4 | October 2nd, 2004 05:03 PM |
date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |