Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 193 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
