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
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Need help using sysdate in Person Selection Fast Formula

    edited Sep 5, 2020 12:10AM in Benefits 6 comments

    Summary

    Need to determine if the person's age ends in 0 or 5 in the current year, i.e. 20, 25, 30, 35

    Content

    Hi All,  I am working on a FF to determine if an employee will be turning 20, 25, 30, 35, 40, 45, etc in the current year. I am able to write a query to compare the birth date to the sysdate and calculate the person's age, and then I can substr the last digit of the age to check if it is 0 or 5. I am having trouble getting this to compile in the FF though. I am hoping you can point out my mistakes.

    DEFAULT for PER_ASG_DATE_OF_BIRTH IS '4712/01/01 00:00:00' (date)

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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