You need to sign in to do that
Don't have an account?
Erin 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!
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!
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!!