Created a calculated date from another date Field

Topic Labels: Automations
973 2
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

I have an EVENTS table with an EVENT Date, I am trying to use automation to create a record in a Related TASK table that uses 1 week before the event Date as the Task Due Date,

I thought perhaps I could use the EVENT Date-7 but that didn’t work. I don’t know what to put in the Task Due Date field in the Create Record automation.

Any help would be appreciated.

2 Replies 2

Automations currently cannot calculate values (unless you use a Scripting action). You need to use a formula field in the table of your triggering record that calculates the due date. Then in the Create Record action, use the value of the formula field.

DATEADD({Event Date}, -7, 'days')
7 - App Architect
7 - App Architect

Thanks, Kuovonne. I was afraid that was the best solution. Much appreciated.