Remedy Smart Reporting - How to Add +7 Days to a Date Field ?

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    9.1.03 and lower versions



    QUESTION:

    How to Add +7 Days to a Date Field ?


    ANSWER:

    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:
       
      DATEADD('day',7,   `HPD:Help Desk`.`Submit Date` )   
      
    Now use the calculate field as required in the reports to get the desired result. 

      

     


    Article Number:

    000156193


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles