Date field appear as long integer

  • Thread starter Thread starter John D via AccessMonster.com
  • Start date Start date
J

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.
 
These look like Unix date/time values. If so, this should do the job:

AccessDateValue = DateAdd("s", UnixTimeStamp, #01/01/1970#)
 
Bundle of thanks. Yes, it works for me.


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

AccessDateValue = DateAdd("s", UnixTimeStamp, #01/01/1970#)
Click to expand...
 
Back
Top