ctime conversion in Access

  • Thread starter Thread starter Ulrich
  • Start date Start date
U

Ulrich

I am working eith a database (over ODBC linked tables)
that shows date and time values as ctime (seconds since
00:00 on January 1st 1970)

For my queries and reports, I need to convert these
values from ctime format into normal date / time format.

Can anyone tell me how to do this?


Thanks,


Ulrich
..
 
CDate(([Fld]/(86400))+25569)

Where Fld is the name of the field that contains the number of seconds since
midnight on 01/01/1970.

P
 
Back
Top