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.
Help with Fast Formula for Enrollment Start/End Date on Absence Plan
Summary
Howdy, I'm looking for a fast formula that will provide 30 days prior to July 4th as Enrollment Start Date and 180 after July 4th as Enrollment End Date. See pseudo code below.Content
/* Enrollment Start Date Fast Formula Pseudo Code */
currentDate = GETCURRENTDATE
currentYear = LEFT(currentDate, 4) -- get the first 4 characters of currentDate aka the current year assuming date format is: '2019/1/1 00:00:00'
enrollmentStartDate = CONCAT(currentYear, '/06/04') -- 30 days before July 4thRETURN enrollmentStartDate
/* Enrollment End Date Fast Formula Pseudo Code */
currentDate = GETCURRENTDATE
currentYear = LEFT(currentDate, 4) -- get the first 4 characters of currentDate aka the current year assuming date format is: '2019/1/1 00:00:00'
Tagged:
0