function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Admin CSMAdmin CSM 

Formula to create automation two weeks before date

Hiya,

Just trying to create a process automation that sends an email alert when it's two weeks before a date of birth.

Can anyone help?
Mahesh SMahesh S

Hello 

If its just a formula, then try this (date_of_birth__c is your DOB field)

 date_of_birth__c - 14

this will give the 2 weeks before date and do you automation for send email

Mark as Best Answer, if its helps

Thanks

Mahesh
Admin CSMAdmin CSM
Hi Mahesh, wouldn't this solution include the birth year though and look for 14 days before that?

For example, if a birthday is 14th February 1993, it would only run on 1st February 1993 which won't work for this purposes.

For context, I need it as an alert so we know to send a birthday card to a supporter
AR Khan 2AR Khan 2
See the best office chairs here: https://chairsalone.com/best-office-chairs-for-sciatica/