Converting UNIX time

[sharon.chapman7]

Hi,
I am trying to convert a UNIX Timestamp to a normal date. I am using Microsoft Access 2003 on an XP Operating system. I am getting a runtime error #6. Can someone please tell me how to fix this? Here is my code:

UNIXDateTimeStamp = 1306347240612

Public Function sDate(UNIXDateTimeStamp As Double)
sDate = DateAdd("s"), UNIXDateTimeStamp,"01/01/1970 hh:mm:ss")


End Function

[RuralGuy]

See if this link helps with the epoch datetime: http://www.newgrove.co.nz/stuff/convert_datetime.php

[sharon.chapman7]

Ruralguy,
It turns out I had to many digits. Once I knocked it down to 10 digits, it ran correctly. Thanks for your quick reply.

Sharon

[RuralGuy]

That's great! Thanks for posting back with your success.