General information
Title:
Funky cDate Conversions
I have users that enter dates such as "01012001" in a date field,
the validate method calls cDate(), which I would expect to return 01/01/2001,
but check it out:
? cDate("01012001")
10/5/4670
? cDate("010101")
8/27/1927 ' Didn't see this one coming
Star trek dates! Obviously if the dashes or slashes are in the date, it works correctly. Rather than writing my own routine to insert them, does anyone know of a quick date conversion that works correctly (or even explain the magic under the hood here?). There doesn't seem to be behind the scenes information on how VB is coming up with the results...
TIA,
Ed VanDuyne
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only