Date serial No.s to date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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


Adam said:
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
Click to expand...
regular format I need to use e.g. dd/mm/yyyy?
 
Adam said:
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
Click to expand...
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
Click to expand...


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.
 
Back
Top