How to convert Excel serial date into Access date format?

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
 
D

Douglas J. Steele

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
 
R

RADO

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top