DATE2JULIANDATEJDE

Description

Returns the JD Edwards-formatted date, which is a 5 or 6 character string value representing the number of years since 1900 and the current day of year; the 2 values are concatenated together.

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

DATE2JULIANDATEJDE ( date )

Parameter	Description
date	A Gregorian/common date (as text or a source field) to be converted to a JDE-formatted date in the target field.

Examples

The following function returns the JDE-formatted date "109278":

DATE2JULIANJDE("10/10/2009")

If source field S47 contains the common date "January 1, 2003", the function returns the JDE-formatted date "103001":

DATE2JULIANDATEJDE(S47)