Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Calculate age as of first of calendar year in Age Determination Fast Formula
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):
Tagged:
0