Leap Day - February 29

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anita Taylor - 20 Jan 2005 14:43 GMT

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.

Reply to this Message

Lynn Trapp - 20 Jan 2005 14:50 GMT

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.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

>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.
[quoted text clipped - 8 lines]
> this
> -- an easy way to get around this.

Reply to this Message

Anita Taylor - 20 Jan 2005 14:59 GMT

>>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.

Reply to this Message

Lynn Trapp - 20 Jan 2005 15:48 GMT

I'm glad it works for you.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

>>>Try entering 2/29/2004 (2004 was a leap year)
>
[quoted text clipped - 3 lines]
>
> I appreciate the tip.

Reply to this Message