Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 279 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Filter to return the last day of the current month
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
Answers
-
Hi Crystal, I recommend that you try posting your question on the specific Reporting and Analytics app forum to get more expert eyes on your question. for example.
0
