acess 2002 & julian dates

[laura]

Is there a way to convert a julian date field to a date
field?

 

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

 

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

 

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