Help

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

Solved
Jump to Solution
1115 6
cancel
Showing results for 
Search instead for 
Did you mean: 
hernandez24
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-05-29 at 1.30.55 PM.png

With the formula field being set up like this:
Screenshot 2024-05-29 at 1.30.59 PM.png

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

Screenshot 2024-05-29 at 1.30.46 PM.png

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?

See Solution in Thread

6 Replies 6
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2024-05-29 at 1.30.55 PM.png

With the formula field being set up like this:
Screenshot 2024-05-29 at 1.30.59 PM.png

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

Screenshot 2024-05-29 at 1.30.46 PM.png

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?

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.

 

Hi all, I actually have the same issue, but haven't been able to solve it following all the solutions I found. I hope someone can put me in the right direction!

I have a main Table called Acquisitions for a real estate company, with a series of records and information about each deal. I created a Tasks table and an automation that creates a series of tasks when a deal is moved to Won. 

In the Tasks table, I created a "Due Date(+7)" field with a formula:

DATEADD({Start Date}, "+7", "days")

which works fine.

The Start Date field is set to be current day by default and works fine. When the task is automatically created, that field is populated correctly with current date.

I have created a few of those: Due Date(+1), Due Date(+7), etc. Which sets the Due Date 1 or 7 days after the Start Date, for instance.

 

Now, the issue.

I need each task to have a Due Date and am looking to do so by pointing the Due Date field to a specific Due Date (+1, +7, etc). When setting the automation for the new tasks, I point the "Due Date" Field to one of those, but it returns a Token, or string, not the actual date the shows in the field, as shown in picture:

 

Lucas_Landtwist_4-1739213476303.png

Lucas_Landtwist_3-1739213442229.png

What am I doing wrong? 

Thanks in advance, Lucas

 

Hmm, that's super interesting and I've not seen that before I'm afraid.  If I were you I'd try recreating the formula fields and the automation itself to see if it goes away

As a data point, I just tried setting it up and it seemed to work fine:

Screenshot 2025-02-11 at 12.42.33 PM.png

Link to base

Hey Adam, thank you immensely for your help, really appreciate it.

I managed to solve it looking at your Table setup!
What I was doing wrong was that I was creating those Due Date fields in the Task record, and not in the Main table. I set up 2 date fields in the main table (due date+1, due date+7), where the +1 and +7 fields are a formula like (DATEADD(Today(), "+7","days"). I then created a Due date field in the Task table and set the automation to populate that field with either the Due Date+1 or Due Date+7 fields. It works perfectly!

The issue that I'm facing now (of course) is that those dates will change every day, since they depend on the Today() formula, which is not the idea. I'd like the due date to be fixed to +7 days from the day the automation is triggered.
I tried creating a Start Date field in the main table, change the +1 and +7 fields to (DATEADD({Start Date}, "+7","days") and set the automation to print current time on Due Date when triggered, but it's not working.

Any idea?

Thank you again for your support, much appreciated!

Hmm, so you're populating the 'Start Date' field manually before you trigger the automation, right?  Or is it that you want the automation to populate that as well?