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


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"RADO" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

Thanks, Doug - Happy Holidays!


"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> 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
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "RADO" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> >
>
>