JULIANDATEJDE2DATE

Description

Returns the Gregorian/common date for the supplied JD Edwards-formatted date.

The JD Edwards "Julian" date format stores dates in a string field (5 or 6 characters, depending on the year) in the format (Y)YYDDD:

YY or YYY represents the two or three digit year. The year from 1900 to 1999 is shown as two digits (00 to 99). Starting with the year 2000, the year is three digits (with 2000 converted to 100).
DDD is the day number from January 1.

So, July 4, 2010 (07/04/2010) is represented in JDE format as 110185.

Syntax

JULIANDATEJDE2DATE ( julian_date_jde )

Parameter	Description
julian_date_jde	The JDE-formatted date to be converted to common date format.

Examples

The following function returns the common date for the JDE-formatted date 110183 as "07/02/2010":

JULIANDATEJDE2DATE (110183)

To return the JDE-formatted date stored in source field S9, enter the function as:

JULIANDATEJDE2DATE( S9 )