Description
Returns the Gregorian/common datetime for the supplied Julian datetime.
Julian dates (abbreviated JD) are a continuous count of days and fractions since noon Universal Time on January 1, 4713 BCE (on the Julian calendar). The time of day is represented by a decimal fraction. Since the Julian day starts at noon, .5 is midnight, and .75 is 6:00 a.m.
The Julian date and its constituent parts are often used by computer programs for calculations involving dates. The time between any two dates can be obtained by subtracting one from the other.
The day of the week for any Julian day can be calculated by taking the remainder after dividing the integer part by 7."
For more information: http://it.toolbox.com/wiki/index.php/Julian_date
Syntax
JULIANDATE2DATETIME ( julian_date )
| Parameter | Description |
|---|---|
| julian_date | The Julian date to be converted to Gregorian/common datetime. |
Examples
The following example returns the common datetime for the Julian date 2455270.5 as 3/15/2010:
JULIANDATE2DATETIME(2455270.5)
To return the Julian date stored in source field S9, enter the function as:
JULIANDATE2DATETIME( S9 )
See also