Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Absence Balances

edited Apr 29, 2020 11:36PM in Reporting and Analytics for HCM 6 comments

Content

Hi all - I am working on a report to show absences taken during a period of time, and I have it just fine for calculating how many absences someone has taken in a calendar year.  However, I am working on absences taken in an anniversary year.  I understand the Plan Period Start Date is not a field for us to report on yet, so am trying to do a workaround.

So if someone has their absence plan balances reset on their anniversary (based on plan enrollment date), I would look at the day/month of that enrollment start date but then the year of the current year.  I can work out the formula if I can just figure out how to pull day/month off a date...unfortunately I cannot get EVALUATE to work and it doesn't seem to like it if I strip the month and strip the day and then CONCAT together. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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