You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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

edited Sep 21, 2020 11:31PM in Reporting and Analytics for HCM 3 comments

Summary

How can I use the TIMESTAMP SQL to report from a rolling 12 months but from the beginning of the month I'm in

Content

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

20B

Code Snippet

TIMESTAMPADD(SQL_TSI_MONTH,-11,CURRENT_DATE)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!