This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Smart Reporting Remedy
19.02 versions and above
How to Add +7 Days to a Date Field ?
To get a date + 7 days, has been fixed in version 9.1.04 patch 02 release.
Below is the work around for this using the Freehand SQL function:
Example: The field that you want to add days to is "Submit Date"
- Copy the SQL for the field so we can get the name of the field at database level.
SELECT DISTINCT `HPD:Help Desk`.`Incident Number`, `HPD:Help Desk`.`Submit Date`FROM `AR System Schema`.`HPD:Help Desk`
- Use the following SQL statement on the Freehand SQL:
Now use the calculate field as required in the reports to get the desired result.
Note: Freehand sql functionality supported on 19.02 versions and above.