Thread: Date function that changes Julian to Gregorian Dates?
View Single Post
  #2  
Old September 21st, 2006, 10:26 PM posted to microsoft.public.access.queries
John Vinson
external usenet poster
  
Posts: 4,033
Default Date function that changes Julian to Gregorian Dates?
On Thu, 21 Sep 2006 13:34:02 -0700, Goose
wrote:

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]