Remedy Smart Reporting - In CASE Statement If The Output Is A Date, It Is Not Displayed In The Report

Version 5
    Share:|

    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.04 versions and below



    QUESTION:

     
        
    • Why date outputs are not getting displayed on a report if used in a CASE statement output?
    •  


    ANSWER:

    When you use a case statement any date field gets transformed to the raw value that is on the database, in this case an Epoch date, in fact if column format gets changed to "Raw Formatter" the Epoch numbers will be displayed.

    Note:

       
    • 18.05 and above versions this is working fine.
      
       
    • There is a workaround on lower versions, refer to the file attached.

     


    Article Number:

    000160008


    Article Type:

    FAQ/Procedural



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