How do i convert a date formatted like: 3/8/2010 (string) to its corresponding seriel?
S Steve P Jan 14, 2010 #1 How do i convert a date formatted like: 3/8/2010 (string) to its corresponding seriel?
V vanderghast Jan 14, 2010 #2 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
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
S Steve P Jan 14, 2010 #3 Van, Thats exactly what i needed. I just formatted it differently with: Format([date],"mmddyyyy") THANKS AGAIN!!!
Van, Thats exactly what i needed. I just formatted it differently with: Format([date],"mmddyyyy") THANKS AGAIN!!!
