Date from make to airtable

[Martin]

Hi,

I’ve got a crazy issue.
Today, we’ve got December 1st 2022, right?
(If I change month and day it’s January 12th.)

In my scenario I want {{formatDate(now; “DD.MM.YYYY HH:mm”; “Europe/Berlin”)}} insert to airtable.
And somehow month and day got changed in airtable …
Additionally airtable doesn’t take the correct time …

Best regards,
Martin

[make_expert]

Hi @Martin
You can’t insert formatdate data into a date field in airtable. Formatdate makes a dateTime object into a text, so you need to add a parsedate to wrap your formula, parsedate makes formatdate a datetime object.

[alex.newpath]

It is actually quite funny to read that in a no code system like make one has to be concerned about data types still in 2022.

[Martin]

Thank you very much.