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")
but I don't know if the conversion algorithm is correct.
Moreover, with such huge numeric values, DateAdd will return an 'error 6: Overflow'. Try to convert the UNIXDateTimeStamp from seconds to a bigger unit: hours, minutes or days first (/360, /60 or /8640).