Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Created a calculated date from another date Field

Topic Labels: Automations
231 2
Showing results for 
Search instead for 
Did you mean: 

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

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