Date function that changes Julian to Gregorian Dates?

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

 

[John Vinson]

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.

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]