Please enable JavaScript to view this site.

From version 7.0.00 - This program compares two dates returning if the To date is greater than (GT), less than (LT) or equal to (EQ) the From Date.

Note: If there is an error in the supplied dates or date formats then blank will be returned.

Parameter

In

Len

Out

Len

PARM1

From Date string

50

Compare value:

GT, LT, EQ or blank

2

PARM2

From Date format (default *DMY)

7

-

 

PARM3

To Date string

50

-

 

PARM4

To Date format (default *DMY)

 

-

 

PARM5

-

 

-

 

PARM6

-

 

-

 

Valid Date Formats

This is where you can specify the format of the date string to be converted. All valid date separators will be removed automatically before comparing. The valid date separators are the slash (/), hyphen (-), period (.), and comma (,).

Example Date Format

If your date is in the format mm/dd/yy you would specify *MDY as your Date format.

Format

Description

*MDY

The date has the month, day, year format, mmddyy.

*MDYY

The date has the month, day, year format, mmddyyyy.

*DMY

The date has the day, month, year format, ddmmyy.

*DMYY

The date has the day, month, year format, ddmmyyyy.

*YMD

The date has the year, month, day format, yymmdd.

*YYMD

The date has the year, month, day format, yyyymmdd.

*CYMD

The date has the century, year, month, day format, cyymmdd, where c is 0 for years 1928 through 1999 and is 1 for years 2000 through 2071.

*JUL

The date has the Julian format, yyddd.

*ISO

The date has the International Organization for Standardization (ISO) date format, yyyy-mm-dd.

*USA

The date has the United States date format, mm/dd/yyyy.

*EUR

The date has the European date format, dd.mm.yyyy.

*JIS

The date has the Japanese Industrial Standard date format, yyyy-mm-dd.

*LONGJUL

The date has the long Julian format, yyyyddd.