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