Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Report Absence based on rolling 12 months from start of month
Summary
How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm inContent
Hi
I would like to report absence on a rolling 12 months but not from today. I need the report to show from the beginning of the month.
So for example, if I'm in September 2020 and today is 22nd September 2020, I want to show the rolling 12 months from 1 October 2019.
At the moment, the report is showing a 12 month period from 22nd October 2019 and excludes the beginning of October's absence.
Thank you.
Version
20BCode Snippet
TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE)
Tagged:
1