Created a calculated date from another date Field

[Brite_Admin]

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.

[kuovonne]

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')

[Brite_Admin]

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