Cannot update a field with dates

[Clement_Lapierr]

Hello everyone,

I am trying to follow ongoing contracts on a timeline view. However, the timeline will not display items that don't have a Start and End Date.

Following  some other topics, most notably this one, I am trying to find a workaround where an automation automatically updates the End Date to match Today's date.

A Checkbox is ticked for all contracts flagged as "Ongoing". The "Find" step locates the ones where "Ongoing" is ticked, and the "Update Record" steps supposedly updates all End Dates with the "Today'scDate" field value.

However, as seen on the attached screenshot, I get an input error. I used the "Find & Update" method quite frequently and never got this result before. I usually use "When record matches conditions" trigger, maybe the error lies within the trigger ? 

Also attached is the formula of my "Today's Date" field in case the error lies in the formatting, but I checked it so it matches Airtable's format (I am in Europe).

Thanks in advance !

[TheTimeSavingCo]

Could you try changing your formula to just be `TODAY()` and attempting the automation again?

[siliceous]

@TheTimeSavingCo 

I'm curious - why is it that you get to have a link to your website in your signature when others don't? I've been told by the moderators here that it is against "Community Guidelines".

[Clement_Lapierr]

Hello Adam,

Thank you for your answer ! I just tried it, and got the same error unfortunately.

[Clairerockwood]

@Clement_Lapierr did you find a solution to your issue? I am encoutering the same issue "Received invalid inputs"