L
laura
Is there a way to convert a julian date field to a date
field?
field?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
Is there a way to convert a julian date field to a date
field?
Which of the many types of Julian dates do you mean? The term has
many, many meanings - from the astronomical Julian date (a day count)
to the military yddd (last digit of year and day number), or the likes
of 04173 or 2004173...
All of these can be translated, but of course the method depends on
which one you mean! If it's '2004173' try
DateSerial(Left([JDate], 4), 1, Right([Jdate], 3))
D
Douglas J. Steele
What's your definition of Julian Date?
Assuming it's yyyy-ddd, where ddd is a value between 1 and 365 (366 in leap
years), so that today is 2004-173, you can add the value of ddd to Dec.
31st of the previous year:
DateAdd("d", 173, #12/31/2003#)
If you mean a true Julian Date (a continuous count of days and fractions
since noon Universal Time on January 1, 4713 BCE (on the Julian calendar)),
it's a bit more difficult.
Assuming it's yyyy-ddd, where ddd is a value between 1 and 365 (366 in leap
years), so that today is 2004-173, you can add the value of ddd to Dec.
31st of the previous year:
DateAdd("d", 173, #12/31/2003#)
If you mean a true Julian Date (a continuous count of days and fractions
since noon Universal Time on January 1, 4713 BCE (on the Julian calendar)),
it's a bit more difficult.
J
John Vinson
If you mean a true Julian Date (a continuous count of days and fractions
since noon Universal Time on January 1, 4713 BCE (on the Julian calendar)),
it's a bit more difficult.
Not all THAT difficult... <g>
CDate([JDate] - 2415018.5)