If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date function that changes Julian to Gregorian Dates?
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. |
#2
|
|||
|
|||
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] |
Thread Tools | |
Display Modes | |
|
|