Convert UNIX Timestamp to Access date and time

[msf11]

I am importing a file into a microsoft access database that includes a unix timestamp which is in UTC (for example: 1066038603 = 10/13/2003 09:50). How can i convert this number into a date and time that can be recognized by microsoft access. Is there an access function that can convert this date?

Thanks for the help!

 

[CajunCenturion]

Unix stores it's time as the number of seconds since 01/01/1970 00:00, so to convert it, you can use the following expression

CurrTime = Format(DateAdd("s", 1066038603, "01/01/1970&quot, "mm/dd/yyyy hh:mm&quot

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein