Using DATE constants in SORT INCLUDE
For comparing with past dates use above pre-defined constants, substract the
days from DATE1P (ex. DATE1P-11 ... means substract 11 days from current date )
subtract months from DATE2P, subtract days from DATE3P formats respectively.
For comparing with future dates.. the same rules applies. add number of days to
to current date. (ex. DATE1P+30.. means add 30 days to current date), add
months to DATE2P, add days to DATE3P.
If you want to use date constants as character value remove letter P from the constants
(EX. DATE1 is equals to C'20121110' )
Working with DATE Constants.
We can use current date, past date, future dates to compare with input fields.
Here is the format of the dates avaiable to use in SORT INCLUDE.
For Current Date use one of the Constants.
Available pre-defined constants Format of the date.