How to convert Excel serial date into Access date format?

  • Thread starter Thread starter RADO
  • Start date Start date
R

RADO

Hi all,

I am importing a file from Excel (2002), which contains dates in Excel
internal format (ie., 37973). How do I make them look like "12/19/2003" in
Access?

Thanks!

RADO
 
All you should have to do is format them.

That number (37973) represents the number of days since 30 Dec, 1899: it's
how dates are stored in VBA.

?Format$(37973, "yyyy-mm-dd")
2003-12-18
 
Thanks, Doug - Happy Holidays!


Douglas J. Steele said:
All you should have to do is format them.

That number (37973) represents the number of days since 30 Dec, 1899: it's
how dates are stored in VBA.

?Format$(37973, "yyyy-mm-dd")
2003-12-18
Click to expand...
 
Back
Top