Date conversion Issue

dhay1999 · May 29th, 2007, 02:03 PM

I have an access table that has date/times stored like the following...

39198.810243 which according to the report it generates is
4/26/07 7:26:45 PM

is this some form of a julian date?

A serial date?

How can I convert this to an actual date/time? Anything I have found gives me an error, or i'm undertain of what sort of julian date it needs to be converted to.

dhay1999 · May 29th, 2007, 03:01 PM

In case anyone else needs this, I Found it.

CVDATE() function in access

http://support.microsoft.com/kb/210276

Thanks!

mmcdonal · May 30th, 2007, 06:47 AM

Hiya,

   www.microsoft.com has lots of articles on this issue. The first part of the date/time number (before the .) is the number of days since December 31, 1899 (I think) and the second part is the number of seconds past midnight of the day (I think).

   This is usually found in a SQL Server database, and not Access. How did you get it there?

   Did you work this out for yourself? It looks like it.

mmcdonal