Clarity

 View Only

Jaspersoft Ad Hoc Views and Report - Period Start date incorrect

  • 1.  Jaspersoft Ad Hoc Views and Report - Period Start date incorrect

    Posted Jan 24, 2020 05:06 PM
    I was wondering if what may be causing the period start date to be a day earlier.  Originally, we had thought the midnight rule came to place, but broadcom support didn't believe that was the case. 

    For example, I will use the datawarehouse table dwh_tme_sheets and the period start date.  When I run it on the ad hoc view or a report, I get a date that is incorrect and usually (not all the time) a day before. 

    Is there a special rule, forumula, or function that I can use to correct this?

    Many thanks