The DATE2SMALLJUL function converts a conventional date (YYYYMMDD) to small Julian date format, returning a five (5) digit value in YYDDD format.
Category
Date / Time
Syntax
DATE2SMALLJUL(source_date)
Parameter and Description
| Parameter | Description |
|---|---|
| source_date |
This parameter specifies a source date in YYYYMMDD format. |
Example
Determine the Julian day from the date January 31st, 2000 and map the result to target field SMALL_JULIAN_DATE.
NEWDATE = AFTER (20121127, '5YY', '3MM', '2DD')
Returns a date value of 20180301 and maps the result to the target field.
Add 3 days to date 12/31/2011 and map the result to field NEWDATE.
SMALL_JULIAN_DATE = DATE2SMALLJUL (20000131)
Returns the value of 031.