Date function that changes Julian to Gregorian Dates?

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

Guest

Is there a function or expression that changes a Julian date (e.g 106094) to
a Gregorian Daten (4/4/2006). I haven't had any luck locating one. Thanks.
 
Is there a function or expression that changes a Julian date (e.g 106094) to
a Gregorian Daten (4/4/2006). I haven't had any luck locating one. Thanks.
Click to expand...

There are many flavors of "Julian Dates" - astronomical JD, Modified
Astronomical, military, etc. I am GUESSING that yours uses 106 as the
number of years since 1900 and 094 as the number of days into the
year?

If so, try

DateSerial(1900 + [JulianDate] \ 1000, 1, [JulianDate] MOD 1000)


John W. Vinson[MVP]
 
Back
Top