|
JULIAN2DATE |
Scroll |
The JULIAN2DATE function converts long Julian date to a conventional date in YYYYMMDD format. A long Julian date is in YYYYDDD format, where DDD is the number of days that have elapsed since the beginning of the calendar year.
Category
Date / Time
Syntax
JULIAN2DATE(date_value)
Parameter Descriptions
date - This parameter specifies a date value in Julian format. The value can be a field from a source datastore, a variable or the result of another Function.
Example
Convert the Julian date 2000031 into a conventional date format and map the result to target field CONV_DATE.
CONV_DATE = JULIAN2DATE (2000031)
Returns the value 20000131
