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 and Description
| Parameter | Description |
|---|---|
| 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 which is the ISO date format:
year
2000
month
01 (January) and
day
31