Hi all,
I was have been using the following filter since mid-September which has been dynamically returning the last day of the current month up until today, 10/31/2024 when it failed.
"Fiscal Calendar"."Fiscal Period End Date" = TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(CURRENT_DATE) * -1 , TIMESTAMPADD(SQL_TSI_MONTH, 1, CURRENT_DATE))
When running the report later in the afternoon, the report ran but returned the last day of the following month, 11/30/2024. I'm guessing that I need to adjust the statement to subtract 10hrs to account for the time difference between HST and UTA.
Would someone be able to help me with this?
Many Thanks,
Crystal
