Unix Date/Time Formatting

[pagec]

Hi All,

I have a slight problem, which I am sure a few of you know the answer to! I am linking Access to a table in Remedy Helpdesk in order to run some reports. However, Remedy stores its date/time fields in a unix format (the number of seconds since Jan 1st 1970), causing Access to display them as standard numbers when running the report.

Is there a way to convert these seconds into days (not worried about the exact time, just the date)? We can do this through Crystal Reports :
(DATE(1970,1,1)+(TRUNCATE({PSHD_S_HELPDESK.Arrival_Time}/(60*60*24))))
but I am at a loss when it comes to Access!

Any help you can give would be most appreciated!!

Thanks,
Chris

 

[padinka]

DateAdd("s",[Your field],"1/1/1970&quot
Trisha
padinka@yahoo.com