10 digit date

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hello,

I have a query where one of the fields has a 10 digit date. It's some UNIX
format that represents seconds from the year 1970.

Does anyone know of an easy way to convert this to a short date like
1/1/2009?

Thanks for your help.
 
Joel said:
Hello,

I have a query where one of the fields has a 10 digit date. It's some UNIX
format that represents seconds from the year 1970.

Does anyone know of an easy way to convert this to a short date like
1/1/2009?
Click to expand...


Use something like:

DateAdd("s", [seconds field], #1/1/1970#)
 
Brilliant, that worked. Thanks very much.

Marshall Barton said:
Joel said:
Hello,

I have a query where one of the fields has a 10 digit date. It's some
UNIX
format that represents seconds from the year 1970.

Does anyone know of an easy way to convert this to a short date like
1/1/2009?
Click to expand...


Use something like:

DateAdd("s", [seconds field], #1/1/1970#)
Click to expand...
 
Back
Top