Help

Trigger formula field update with automation

Topic Labels: Automations Formulas
Solved
Jump to Solution
535 1
cancel
Showing results for 
Search instead for 
Did you mean: 
johnch
4 - Data Explorer
4 - Data Explorer

Hello, looking for help on how to trigger the update of formula field when a record reaches a condition. My example is the following: I have a "Birth Date" field which contains the birthdate as Date. I have a formula field which calculates the current year "Anniversary Date": 

DATETIME_PARSE(YEAR(NOW())&"-"&DATETIME_FORMAT({Birth Date},'MM-DD')).
How can I trigger the update of this "Anniversary Date" when the record reaches the day after the anniversary?
 
1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

`IS_AFTER()` is what you're looking for I think, along with a `DATEADD() to add one day to the anniversary date so that it's the day after the anniversary

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

`IS_AFTER()` is what you're looking for I think, along with a `DATEADD() to add one day to the anniversary date so that it's the day after the anniversary