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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ldata/200511/1

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

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

On Tue, 22 Nov 2005 20:35:14 GMT, "John D via AccessMonster.com"
<u10695@uwe> wrote:

>
>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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Bundle of thanks. Yes, it works for me.


John Nurick wrote:
>These look like Unix date/time values. If so, this should do the job:
>
> AccessDateValue = DateAdd("s", UnixTimeStamp, #01/01/1970#)
>
>>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 [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.

--
Message posted via http://www.accessmonster.com