Leap Day - February 29

[Anita Taylor]

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.

 

[Lynn Trapp]

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.

 

[Anita Taylor]

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.

 

[Lynn Trapp]

I'm glad it works for you.