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

Calculate age as of first of calendar year in Age Determination Fast Formula

edited Aug 23, 2024 5:31PM in Benefits 2 comments

Summary:

Hello Experts,

I want to modify an age determination ff we have. There are 2 conditions, for some life events, I want the date to be the 'occurred date' and for other life events, I want the date to be 'first of the calendar year'. I used 'TRUNC (SYSDATE, 'YEAR')' for the first of calendar year but it didn't work. Getting the local variable not declared error. I have declared it and error still persist. Is there a DBI or function that can get the first date of the calendar year (1/1/….)Please help!!!

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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