EDATE
Syntax
EDATE date_value
Syntax explanations
date_value can be specified as any of the following:
- TODAY is the same day that UIE runs the batch job to process the records.
- TODAY- nnnn represents nnnn from 0 to 9999 days prior to the day that UIE runs the batch job.
- YYYY-MM-DD or YYYY/MM/DD is the long Gregorian format specifying a four-digit year and two-digit month and day.
- YYYYDDD is the long Julian format specifying a four-digit year and three-digit day of the year.
Rules
If you specify the start date without an end date, the end date is assumed to be the same as the start date.
Examples
EDATE 2007-03-01
In this example, the end date is set to March 1, 2007.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*