Convert date string (ie: 1/3/2010) to seriel

[Steve P]

How do i convert a date formatted like: 3/8/2010 (string) to its
corresponding seriel?

 

[vanderghast]

Use CDate.

? CDate("3/8/2010")
2010.03.08

( In my case, it took the first number as the month; my Regional setting
tell Windows to format my dates in the ISO format, which is year dot month
dot day ).


Vanderghast, Access MVP

 

[Steve P]

Van,
Thats exactly what i needed. I just formatted it differently with:

Format([date],"mmddyyyy")

THANKS AGAIN!!!