Keep receiving "Could not convert string to date." Error when trying to automate Date

[hernandez24]

I have a form where users will enter product details, among those details is the "Field Date", I am trying to set up automation so that when they submit a form and enter a new record, it takes the "Field Date" and subtracts 11 days from it and then enters the new date into the "Feedback Due" column for that product.

I have a TRIGGER set to recognize when the "Field Date" is not empty. My ACTION is set to Update Record, then in the "Feedback Due" I am trying to use DATEADD({Field Date}, -11, 'days') to calculate the new date.

I just get "Field "Feedback Due" cannot accept the provided value: Could not convert string to date."

Both columns are set to the same date format. I am new to airtable and would appreciate any help anyone can provide to get me going in the right direction.

[TheTimeSavingCo · Accepted solution]

Hm if I were you I'd set up my data like so:

With the formula field being set up like this:


Which would allow me to set up my automation like this:

Link to base

---
I'm curious why you want the "Feedback Due" field to be a date field though.  Is it that the "Field Date" value can be updated after the form is submitted and you want the "Feedback Due" field to remain unchanged?

[hernandez24]

Thank you! that works for me, and yes it is because there will be occasions where we will need to change a due date. (weekends and holidays for example).

I was hoping to be able to perform calculations within the automation, but this way till work too.