Entering criteria for date and time fields

For a date and time field you can enter in the Value field a date and time string. The string must be specified in the output format defined for the field and must be prefixed by the character d to indicate a date string or t to indicate a time string. The following is an example of a date value:

    d'Jan 01, 2014'

where the output format is:

    Mmm DD, YYYY

The following is an example of a time value:

    t'15:30:00.000'

where the output format is:

    HH:MI:SS.999

When a date value is specified the expression generated uses the CMP_DATE external REXX function. When a time value is specified the expression generated uses the CMP_TIME external REXX function.