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.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need help using sysdate in Person Selection Fast Formula
Summary
Need to determine if the person's age ends in 0 or 5 in the current year, i.e. 20, 25, 30, 35Content
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:
1