Access 2003 - Leap year 2008

A

alhotch

Entering a value of 02/29 into a form (mask is 00/00;0/_) and (format is ddd
mmm dd\,yyyy) yields a date of "Thu Feb 1,2029". Entering a value of 02/28
yields a date of "Thu Feb 28,2008". How can I get a value of "Fri Feb
29,2008" for this "leap year" date ? Windows-Control-Regional and Language
Options look OK.
 
D

Douglas J. Steele

You'll need to provide the year as well. To be honest, I don't understand
why you're getting Feb. 28th of next year if you only enter 02/28: I get
Feb. 28th of this year when I do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if Leap Year 12
Set Up Calendar To Account For Leap Years 2
Handling Leap Years 2
leap year date issue in sumif formula 2
How to Handle Feb 28 and 29? 2
2008 Leap Year 4
Leap Year 7
Calculating occupational sick pay entitlement 0

Top