PreDefined Function 'MonthName' In SmartReporting Gives Incorrect Results.

Version 2
    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:

    ITSM In-App Reporting


    APPLIES TO:

    BMC SmartReporting 9.1 SP02



    PROBLEM:

     

       
    • PreDefined Function 'Month' In SmartReporting Gives Incorrect Results.
    •  
    • Issue is seen when there is a DST in place.
    •  
    • The report which has the Submit Date as '01/05/2017 12:33 AM' is displaying the 'Month Name' as April as opposed to May.
    •  
    • The Submit Date with value as '01/05/2017 01:00 AM' is displaying 'Month Name' as 'May'.

     


    CAUSE:

    Issue has been identified as a defect. Underlying JDBC unable to convert the DST.


    SOLUTION:

     

       
    • A defect ID SW00530363 has been created and will be addressed in upcoming releases.

     


    Article Number:

    000138099


    Article Type:

    Solutions to a Product Problem



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