Date serial No.s to date format

[Guest]

Can anyone help

I am pulling data from a Helpdesk 6.1 server table and searching by date
The trouble is the dates seem to be in a serial no. format and not in the regular format I need to use e.g. dd/mm/yyyy

Here are a couple of examples
131334414
13127142

Does any one have an idea of how these serial no.s can be converted to the more useable format

Regard
Adam

 

[Graham R Seach]

Adam,

Without a valid algorithm to convert them, I can see no way of extracting
date values from these numbers.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Can anyone help?

I am pulling data from a Helpdesk 6.1 server table and searching by date.
The trouble is the dates seem to be in a serial no. format and not in the

regular format I need to use e.g. dd/mm/yyyy?

 

[Harvey Thompson]

Can anyone help?

I am pulling data from a Helpdesk 6.1 server table and searching by date.
The trouble is the dates seem to be in a serial no. format and not in the

regular format I need to use e.g. dd/mm/yyyy?

Here are a couple of examples:
131334414
131271427

Does any one have an idea of how these serial no.s can be converted to the more useable format?

Regards
Adam

Adam,
You really haven't given us much to go on. Knowing what dates the
examples represent would have helped considerably.
The only thing I can suggest is that a Unix date was a count of the
number of *seconds,* not days, since January 1, 1970, not December 30, 1899.
Unfortunately ?dateadd("s",(131334414),#1/1/1970#) yields 03/01/1974
1:46:54 am and
?dateadd("s",(131271427),#1/1/1970#) yields 02/28/1974
8:17:07 am
so it's probably not a Unix date.

Best I can do.