Access 2003 Format date/time?

Nell Dipiero: Date/time setting required a full date e.g. 1/1/2000

Luis Farlow: Do other dates work? Are you entering 4 digits or 2? It should work in Access 2003. Prior versions need a patch to account for the year 2000.

Marvella Benward: If your field data type is date/time, you need to at a minimum enter a complete date. In this case, the time will default to midnight.If all you want to capture is year, then you should set up a 4 digit numerical field instead.