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.

Fast Formula for Accruals Plan

edited Dec 8, 2020 9:05AM in Workforce Management 5 comments

Content

Hi 

I have limited FF experience and was hoping this might be a simple question for someone who has more experience. We have a FF which includes calculating the number of days between the employee hire date and the end of the current year. It uses the below line to establish 'the end of the current year':

Effective_end_date = to_date('3112'||to_char(GET_CONTEXT(EFFECTIVE_DATE,'4712/12/31 00:00:00' (date)), 'YYYY'),'DDMMYYYY')

I actually need to establish the end of the next year, not the current. Can I add a +1 somewhere in this line to achieve this? I'm just not sure how to do this. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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