Question Locked

Convert Julian date to standard date.

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am querying a ctree database, from ms access that has dates and times stored in the Julian date format. I would like to locate a function to convert the date to the format MM/DD/YYYY. E.g 2454398 is 10/24/2007 and 4417338 is 12:16 pm. None of the formula's I have seen so far work with this date and time format.

2 replies

by tony hopkinson

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

Unless you drop really lucky first you are going to have figure out how 2544398 is the 24/10/007 if it's something as simple as that many days after the base date.

Then all you have to do is work out the difference between access's day 0 and ctree's
Bring in the date as a number add the diffrence.

Given the time example you provided though I suspect it's not that simple, number of seconds since midnight would make 12:16 43260 !

This discussion is closed to new replies.