Formula For Assigning Benefits Effective Date

Hello-

I'm building a workflow to generate an eligibility file and I need either a formula and/or filter to capture benefits eligibility date based on Hire Date, then only send those that are eligible on the date the file is generated.

Criteria for eligibility is first day of the month following one month of employment

I've looked at some other posts for date time add but am struggling and on a deadline.

Thanks!

Date Time

Accepted answers

RobertOdera

Hi, @katherinetdavita

Check out the below.

I hope you find it helpful - Cheers!

For_Katherinedavita.yxzp

All comments

BS_THE_ANALYST

@katherinetdavita perhaps something like this could help. You may need to tweak the filtering logic at the end:

Sample input:

Adding one month to the hire date:

Some filtering logic:

Last step (if you want this one). You could send those eligible people an e-mail, or you can just output the file as a CSV etc:

DateEligibility.yxmd

katherinetdavita

Hi- Thanks for this, but the eligibility is a little more complicated than just adding a month.

For example, if an employee's hire date is today, 3/30/23, they are not eligible until 5/1/2023

But if their hire date is 4/1/2023, they're eligible 5/1/2023

I'd also rather not have to change the filter date when it runs weekly, but instead filter based on the eligibility date and run date.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335