Access date insert problem -
07-21-2003
, 11:16 AM
We have a timesheet system running in ASP with an Access back-end on
Microsoft Small Business Server 2000. Recently it has come to our
notice that dates do not always insert into a date field correctly.
Most of the time they are right, but recently, when we input
03-07-2003 what was inserted was 03-07-2025. We've also had the years
1930, 1931 and 2015 inserted as well.
I am a bit stumped. The code's OK, the date fields are OK, and most of
the time it works correctly.
Can anyone help.
Thanks |