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!
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.