Skip to main content

Created a calculated date from another date Field

  • February 24, 2022
  • 2 replies
  • 16 views
Brite_Admin
Forum|alt.badge.img+11

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

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • February 24, 2022

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
Forum|alt.badge.img+11
  • Brite_Admin
  • Author
  • Inspiring
  • February 24, 2022

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

Terms & ConditionsAccessibility statement