Please enable JavaScript to view this site.

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 Descriptions

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.

SMALL_JULIAN_DATE  = DATE2SMALLJUL (20000131)

Returns the value 031.