DateTimeSerial to Date

[Samrat]

I have msaccess database. All the date field is stored in this format.
Something like datetimeserial I guess.

For example LoginDate field contain : 1211111322
When I try to query Cdate(LoginDate) it gives me wrong value / Error.

Can you please help me out.

You can reply to (e-mail address removed) as well.

Thanks in advance.
Ashokraja

 

[Douglas J. Steele]

You're going to have to determine exactly what the value represents.

If, for example, that value represents an event on May 18, 2008, it's
possible that the value is being stored as a Unix date (number of seconds
since midnight, January 1, 1970), in which case you can use

?DateAdd("s", 1211111322, #1/1/1970#)
2008-05-18 11:48:42