Date/Time results on our reports are wrong or inconsistent. Do we have any information on getting the appropriate date/time functions or settings for our reports?

Version 1

    Details

    Date/Time results on our reports are wrong or inconsistent. Do we have any information on getting the appropriate date/time functions or settings for our reports?


    Resolution

    The reporting system on the HEAT Cloud product is using Microsoft SSRS. A quick search on Google (or other search engine) will bring back many hits that deal with SSRS date functions and formatting.

    The link below goes to Microsoft and has the basic date functions available when using SSRS. Another good search would be "ssrs date time functions and time zones" on Google if you are having difficulties with date formatting that is Time Zone related.

    https://technet.microsoft.com/en-us/library/aa337153%28v=sql.100%29.aspx