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 Removed) as well.

Thanks in advance.
Ashokraja

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


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Samrat" <(E-Mail Removed)> wrote in message
news:FD2C10A4-5E31-4F3C-A581-(E-Mail Removed)...
>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 Removed) as well.
>
> Thanks in advance.
> Ashokraja