Access 2003 date confusion
Posted on 2007-11-13
I have a MS Access 2003 database with sales date formatted as short date (99/99/0000;0). We enter the date mostly by Ctrl +;. Certainly there are times we manually enter mm/dd/yyyy. All the same the date is formatted corrrectly, say: 11/13/2007. The database run smoothly since 2005 ; and has now accumulated over 12000 records. Recently we found a lot of records showing a funny date format: 0/29/2007. I first though this is an human error. But the 0 month appears in all 2005, 2006 and 2007 between October and November when I sort ascendently. Whereas, the databases I copied on cd's before March 2007 do not show this funny date record. What could have gone wrong? The database is used between 2 computers in a network. One computer was replaced by a new Dell with XP Home this spring and we have some other date confusion since then: although the other computer with XP Professional shows date as formatted: mm/dd/yyyy. The new Dell will show dd/mm/yyyy. Could the new computer a culprit? Or is it an Access issue? Please shed me some light!