0

I have a textbox to enter date into a MS Access database.
I've tried entering 29-02-2000. But it is saved as 28-01-1900 in Access.
I've tried entering 02-20-2000. But it is saved as 01-01-1900 in Access.
My system shortdate format is dd-MM-yyyy.
My system longdate format is dd MMMM,yyyy.
My Access datefield property is date/time with property set as Short Date-19-06-2007 and blank inputmask.
How to solve the problem once and for all irrespective of the system date the program is run in. I'm a beginer.

1
Contributor
1
Reply
10
Views
3 Years
Discussion Span
Last Post by bnitishpai
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.