JDate
Use this function to find the calendar date equivalent of a date in Julian date format.
Julian date format consists of a five digit number; calendar dates appear in the format yyyy-MM-dd hh:mm:ss. (Note that uppercase “M” is used to designate months, and lowercase “m” is used to designate minutes).
Note: The valid range for the JDate function is between 25567 and 402133 (which correspond to 1970 - 3000). Entering an invalid date will cause the following error message to appear: "Invalid JDATE range. JDATE must be between 25567 and 402133."
Do not confuse the JDate function with the JValue function:
Function | Description |
|---|---|
JDate | To find the calendar date equivalent of a Julian date. |
JValue | To find the Julian date equivalent of a calendar date. |
where:
- JulianDate is the five digit number (between 25567 and 402133) representing a date in the Julian calendar to be returned as a calendar date.
- Format is the format of the calendar date to be returned. The default is “yyyy-MM-dd hh:mm:ss”.