JULDAT: Converting From Gregorian to Julian Format
Available Languages: reporting, Maintain
The JULDAT function converts a date from Gregorian format (year-month-day) to Julian format (year-day). A date in Julian format is a five- or seven-digit number. The first two or four digits are the year; the last three digits are the number of the day, counting from January 1. For example, January 1, 1999 in Julian format is either 99001 or 1999001.
Format Settings for JULDAT
JULDAT converts a Gregorian date to either YYNNN or YYYYNNN format, using the DEFCENT and YRTHRESH parameter settings to determine if the century is required.
JULDAT returns dates as follows:
- If the format is I6, JULDAT returns the date in the YYNNN format.
- If the format is I7 or greater, JULDAT returns the date in YYYYNNN format.
Convert From Gregorian to Julian Format
JULDAT(indate, output)
where:
I6, I8, I6YMD, I8YYMD
Is the legacy date to convert or the name of the field that contains the date in year-month-day format (YMD or YYMD).
I5 or I7
Is the name of the field that contains the result, or the format of the output value enclosed in single quotation marks.
Converting From Gregorian to Julian Format
JULDAT converts the HIRE_DATE field to Julian format. It determines the century using the default DEFCENT and YRTHRESH parameter settings.
TABLE FILE EMPLOYEE PRINT HIRE_DATE AND COMPUTE JULIAN/I7 = JULDAT(HIRE_DATE, JULIAN); BY LAST_NAME BY FIRST_NAME WHERE DEPARTMENT EQ 'PRODUCTION'; END
The output is:
LAST_NAME FIRST_NAME HIRE_DATE JULIAN --------- ---------- --------- ------ BANNING JOHN 82/08/01 1982213 IRVING JOAN 82/01/04 1982004 MCKNIGHT ROGER 82/02/02 1982033 ROMANS ANTHONY 82/07/01 1982182 SMITH RICHARD 82/01/04 1982004 STEVENS ALFRED 80/06/02 1980154
GREGDT converts JULIAN to YYMD (Gregorian) format. It determines the century using the default DEFCENT and YRTHRESH parameter settings. The result is stored in a column with the format I8.
GREGDT(JULIAN, 'I8')
For 82213, the result is 19820801.
For 82004, the result is 19820104.