10 digit date

[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.

 

[Marshall Barton]

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?

Use something like:

DateAdd("s", [seconds field], #1/1/1970#)

 

[Joel Allen]

Brilliant, that worked. Thanks very much.

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?

Use something like:

DateAdd("s", [seconds field], #1/1/1970#)