+ Start a Discussion
Erin Lester 4Erin Lester 4 

Formula To Get Process to Trigger on 1/1 each year

This is driving me nuts because I know it should be pretty simple but my brain is having a moment. I have a field that is "today's date" so it updates every day. When that date is 1/1/XXXX, I want my process builder process to trigger. 

Process builder isn't giving me a option for "starts with", so I need a formula that will equal 1/1/current year.

Will DATE(year,1,1) work? I feel like I'm missing something here.

Thanks!
Kumaresan.ManickamKumaresan.Manickam
I am not sure how process builder could help here as this activity is going to be every year you want the builder to get triggered in the first day of the year. I suggest few approachs if it suits for your need:
1) Create a batch job which u can schedule every 1st day of the year so that you dont have to rely on today's date field etc.
2) In your process builder, in the entry condition check the day of the current date field & month of the current date field and if its matches with 1, then fire your process. DAY(today_date__C) , MONTH(today_date__C) like that. Try and see if it helps.

Please let me know if any questions.
Cheer!!