Dates

[Lourry]

Hello all,

I tried to set a date to a variable by:

Const date1 As Date = "1/1/1950 12:00:00AM"

but it only stores 1/1/1950 in the variable, it doesn't store the time! How can I declare it so that it includes the time?

Thanks!

 

[KenHigg]

I think, but not sure, that variants store days as a number where days are everything on the left side of the decimal point and time in minutes, etc are on the right. This being the case, maybe 12am (midnight) has a value of zero. Anyway, try putting in some other time ,say 12:30 am, and see what happens... Just a guess