In a imported SQLite column I have a value i.e.: “12/01/09 00:00:00”. I want to convert this to a correct SQLlite date:
The day is 01, month = 12 and year = 09
I executed this code:
[code] dim newDate as new Date
aStringDate = rs.Field(“P_DOB”).StringValue
if aStringDate <> “” then
Also, make sure you assign the values in Year, Month, Day format. If the day being converted is january 31st, but you’re doing it in February, you’ll end up with March 3rd because the days will roll over.
Another way to handle this would be to create the date using the date constructor: