Dates in Access 2000

  • Thread starter Thread starter CAthoms
  • Start date Start date
C

CAthoms

Is it possible to store the date in access as 01/12/2004
rather than 1/12/2004. Or is it possible when exporting
to a text file to make sure that the date is 01/12/2004
and not 1/12/2004??

I am using access 2000.
 
Just to expand on Arvin's answer, dates are actually stored in Access as 8
byte floating point numbers, where the integer portion represents the date
as the number of days relative to 30 Dec, 1899 (and the decimal portion
represents the time as a fraction of a day). In other words, Access doesn't
store 01/12/2004 or 1/12/2004.

To control how it's displayed, you need to format the output appropriately.
 
Back
Top