Date from make to airtable

Questions & Answers
1

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 …
:thinking:

Best regards,
Martin

2

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.

2 Likes
3

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.

4

Thank you very much. :slight_smile:

1 Like