Help with Fast Formula for Enrollment Start/End Date on Absence Plan — Cloud Customer Connect
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

Help with Fast Formula for Enrollment Start/End Date on Absence Plan

edited May 13, 2021 2:28PM in Workforce Management 4 comments

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 4th

RETURN 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'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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