JValue
Use this function in an equation to find the equivalent of a calendar 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 JValue function with the JDate function:
| Function | Description |
|---|---|
JValue | To find the Julian date equivalent of a calendar date. |
JDate | To find the calendar date equivalent of a Julian date. |
Syntax
JVALUE (SymName|"Date"[, "Format"])
where:
- SymName is TIMEPER symbol from which the Julian date is to be calculated.
- Date is the calendar date to be returned as a Julian date.
- Format is the format of the calendar date. The default is “yyyy-MM-dd hh:mm:ss”.
Syntax example
JVALUE (31/07/2000, "dd/MM/yyyy")