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.