Use date variables to contain the results of date calculations.
For example, to create a date variable that adds 14 days to the date of a customer’s last appointment, you could use the miscellaneous function dateadd, and enter the information in the Variable Builder as follows:
dateadd (<##Master_Query=APPTS.APPT_DATE>, 'day', 14)
When you create date variables:
Use single quotes to enclose text literals.
In the above example, day is enclosed in single quotes as 'day'.
Use single quotes to enclose literal dates.
For example, enter the date of 05-May-00, as '05-May-00'.
Follow the format that is acceptable to your database, or that is defined in the SQR_DB_DATE_FORMAT section of SQR.INI.