I’m setting up a dashboard via google sheets so I have a zap moving dates from Infusionsoft to Google Sheets and it’s working great. Now I have a field that is Date/Time and Zapier doesn’t like the format and can’t recognise it to re-format it.
It looks like 2021-05-16T:00:00:00. With the letter T physically in the value. How would I tell Zapier how to read this using only syntax that the reformatter understands? Speech marks around the ‘T’ perhaps?