Hello everyone, I need help !!! I’m trying to populate a date/time field in Airtable that is set to Local format (14/08/2025). The data I need to retrieve comes out of my Text Parser module in the following format: [Capture d’écran 2025-08-14 à 12.05.33] What I need is to extract the pickup_d…

Hi @morgan_moussier , I think instead of the formatDate() function you need to use the parseDate() function. This function takes in a string + your definition of how the string has to be read and gives back a date. However, I’m not even sure that this is possible. Is the data always like this or do…

Hello @morgan_moussier , Considering the value of pickup_datetime is a string, I would use both parseDate() and formatDate(). First I would replace the word “at“ or in your case “à“ with just a space. Then I would take the resulting string and input it into parseDate() indicating that the format th…

Thanks for your answer. The issue is that Make doesn’t recognize dates in French, so I used a Text Parser / Match Pattern to split all the data from my “date” field, then a Set Multiple Variables module to convert the months into numbers, and finally I combined everything into an ISO date. Anyway, t…

That’s what I was afraid of! @Mary1 ’s formula would have been perfect for English! You went all the way - great job! :smiley:

@morgan_moussier Parsing and formatting dates in other languages can be tricky and ops consuming but you can use Native AI modules by make like “Request Anything”. Here is how you can find and use it. [image] [image] With Weekday [image] AI Makes things a bit easier. Best, @Prem_Patel

Changing date formats from text to Airtable field

Questions

Umer_Jamil August 14, 2025, 7:35pm 3

Hello
You can use the built-in “formatdate“ function of make.

What you have to do is: formatdate(your_current_date; your preferred date format).

Topic		Replies	Views
Date from make to airtable Questions	3	855	December 2, 2022
Parsing dates from Google Sheets to Airtable Questions google-sheets , airtable	1	480	December 7, 2023
Converting the date to the desired format Questions make-api , airtable , stripe	6	189	August 26, 2024
Problems with date format in Airtable Questions connections , airtable , api , chatgpt , error	3	197	June 20, 2024
How to format date into YYYY-MM-DD? Questions date-time-functions , error , format-date	7	189	May 29, 2025

Changing date formats from text to Airtable field

Related topics