# Changing date formats from text to Airtable field **URL:** \ **Category:** Questions\ **Tags:** format-date, regular-expressions, date-time-functions, airtable\ **Created:** [August 14, 2025, 4:22pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588 "2025-08-14T16:22:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![morgan\_moussier](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/morgan_moussier/32/78204_2.png) [@morgan\_moussier](https://community.make.com/u/morgan_moussier)\ **Post date:** [August 14, 2025, 4:22pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/1 "2025-08-14T16:22:45Z")
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’écran 2025-08-14 à 12.05.33](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/5/e559c801c7ddb00c06054584f312f9723d1e4f8d.png) What I need is to extract the **pickup\_datetime** value, convert it into a format that Airtable recognizes, and then insert it into my table correctly. I’ve tried dozens of approaches, but I just can’t get this line to convert properly ! Please, does anyone have the solution ? Thanks, Morgan ---
**Author:** ![Umer\_Jamil](https://avatars.discourse-cdn.com/v4/letter/u/76d3ee/32.png) [@Umer\_Jamil](https://community.make.com/u/Umer_Jamil)\ **Post date:** [August 14, 2025, 7:35pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/3 "2025-08-14T19:35:01Z")
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). ---
**Author:** ![R-SimplifiedWebhooks](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/r-simplifiedwebhooks/32/3914_2.png) [@R-SimplifiedWebhooks](https://community.make.com/u/R-SimplifiedWebhooks)\ **Post date:** [August 15, 2025, 11:59am UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/4 "2025-08-15T11:59:39Z")
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 does it differ sometimes? If it’s always the same you might come up with a way to convert it to a date. First word is the day, then the number… Alternatively, you could feed this to Gemini and ask for a date back. Should work and is basically free too. Best, Richard ---
**Author:** ![Mary1](https://avatars.discourse-cdn.com/v4/letter/m/f07891/32.png) [@Mary1](https://community.make.com/u/Mary1)\ **Post date:** [August 15, 2025, 2:19pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/5 "2025-08-15T14:19:18Z")
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 that was used was dddd D MMMM YYYY H:mm. Finally I would use formatDate() to choose the format that you want. In the example i am showing you i chose DD/MM/YYYY which would result in 18/07/2025. Best, Mary ![dateneeded](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/c/8c300f758d43ec966f30ef26cb9378a4e35ccd82.png) ---
**Author:** ![morgan\_moussier](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/morgan_moussier/32/78204_2.png) [@morgan\_moussier](https://community.make.com/u/morgan_moussier)\ **Post date:** [August 15, 2025, 2:45pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/6 "2025-08-15T14:45:51Z")
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, thanks a lot for your help! ---
**Author:** ![R-SimplifiedWebhooks](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/r-simplifiedwebhooks/32/3914_2.png) [@R-SimplifiedWebhooks](https://community.make.com/u/R-SimplifiedWebhooks)\ **Post date:** [August 15, 2025, 3:12pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/7 "2025-08-15T15:12:32Z")
That’s what I was afraid of! @Mary1’s formula would have been perfect for English! You went all the way - great job! 😃 ---
**Author:** ![Prem\_Patel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/prem_patel/32/93657_2.png) [@Prem\_Patel](https://community.make.com/u/Prem_Patel)\ **Post date:** [August 15, 2025, 3:26pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/8 "2025-08-15T15:26:20Z")
@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](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/b/0b008cc46c70e387a78fe3d7c968392e1b862937.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/7/67aa79901c96948ab5996768ff7c4cf8996435f8.png) With Weekday ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/3/53661dddbd5b87d75f8211ec3d1448c5314a395a.png) AI Makes things a bit easier. Best, @Prem_Patel ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [November 13, 2025, 4:27pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588/9 "2025-11-13T16:27:02Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.