Date field appear as long integer

[John D via AccessMonster.com]

I am working on a access table which is link with some external software (3rd
party software).
Everything works fine but the date/time field is appearing as a long integer
value i.e. 1132675652 or 1132674975 etc. I want to convert this numerical
value to some sensible date and time format. I would really appreciate if
someone can advise how to do this.

 

[John Nurick]

These look like Unix date/time values. If so, this should do the job:

AccessDateValue = DateAdd("s", UnixTimeStamp, #01/01/1970#)

 

[John D via AccessMonster.com]

Bundle of thanks. Yes, it works for me.

These look like Unix date/time values. If so, this should do the job:

AccessDateValue = DateAdd("s", UnixTimeStamp, #01/01/1970#)