# Convert a Text format to a specific Date format **URL:** \ **Category:** Questions\ **Tags:** error, mapping, functions\ **Created:** [January 31, 2025, 1:41pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008 "2025-01-31T13:41:29Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Thierry](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thierry](https://community.make.com/u/Thierry)\ **Post date:** [January 31, 2025, 1:41pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/1 "2025-01-31T13:41:29Z")
### What are you trying to achieve? Hello, I am a beginner with Make and currently want to parse ( Parseur )emails in order to map them into Notion via Make. I have a date in text format (ex : mar. 21 Jan. 2025 OR jeu. 14 Oct. 2025) which I want to convert into a specific date format (21/12/2025 ; DD/MM/YYYY). I am using the following formula, which removes the “.” and specifies my environment “Paris/Europa”, but it is not working. Could you help me? Thank you. parsedate(replace(“{{1.Date}}”; “.”; “”); “ddd D MMM YYYY”; “Paris/Europa”) ### Steps taken so far Tried various formulas proposed by Make and gpt ### Screenshots: scenario setup, module configuration, errors ![2.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/6/464184e54ce71996a0fefc6a544b8ad0cccd9ff7.jpeg) ![1.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/e/2e2b7ee5c9aaf1411a8535a3d57354f137e1dbe2.jpeg) ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [January 31, 2025, 2:20pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/2 "2025-01-31T14:20:09Z")
Hi @Thierry Date in this format will workfine: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/e/6eed5b1de4b203abd3b7afbeb3e337e26ad85aa1.png) Output: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/e/7e3ac9698f9ba8006f104b6fb78fa249593b5d36.png) Make typically works best with: - ISO 8601 (2025-01-21T00:00:00Z) - English formats (`Tue, 21 Jan 2025`) You can try replacing the week day from the date instead of replacing the dot. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/7/b7c67ce7d1eb095e8bf1ff670b6212dfa910656b.png) Output: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/20d163a6562f0c0de1961e22b688419c075acbc1.png) **Best regards,** **Msquare Automation** _Platinum Partner of Make_ @Msquare_Automation ---
**Author:** ![Thierry](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thierry](https://community.make.com/u/Thierry)\ **Post date:** [January 31, 2025, 2:26pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/3 "2025-01-31T14:26:40Z")
Thank you. I test it right away! ---
**Author:** ![Misha-Inactive](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@Misha-Inactive](https://community.make.com/u/Misha-Inactive)\ **Post date:** [February 3, 2025, 10:23am UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/4 "2025-02-03T10:23:31Z")
Hi @Thierry, Could you please mark the solution if it was helpful? It helps us keep the environment organized. Thank you! ---
**Author:** ![Thierry](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thierry](https://community.make.com/u/Thierry)\ **Post date:** [February 3, 2025, 1:56pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/5 "2025-02-03T13:56:54Z")
I understood integration, at least I now understand the principle of formula within a formula. the help of @Msquare_Automation, was more than welcome. I’ve been reading and testing solutions for 3 days. With a pro it’s different…Thanks again @Msquare_automation! ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [February 4, 2025, 9:42am UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/6 "2025-02-04T09:42:39Z")
HIi @Thierry Glad to know your issue is solved now. **Best regards,** **Msquare Automation** _Platinum Partner of Make_ @Msquare_Automation ---
**Author:** ![Thierry](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thierry](https://community.make.com/u/Thierry)\ **Post date:** [February 2, 2025, 7:50pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/7 "2025-02-02T19:50:51Z")
Hi, I’am still stuck with the date format. My question is may be simple but How could I adjust a date format difference in a same flow. for example “31 jan. 2025” and “1 févr. 2025”, dates issued from the same source? ---
**Author:** ![Misha-Inactive](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@Misha-Inactive](https://community.make.com/u/Misha-Inactive)\ **Post date:** [February 3, 2025, 12:38pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/8 "2025-02-03T12:38:24Z")
Hi @Thierry, did you check our Make Academy article about [Date and Time functions](https://www.make.com/en/help/functions/date---time-functions)? Let me know, if it helps. ---
**Author:** ![Thierry](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thierry](https://community.make.com/u/Thierry)\ **Post date:** [February 3, 2025, 1:59pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/9 "2025-02-03T13:59:29Z")
Hello Misha, thank you for your interest. Yes I read and reread and reread, but I can’t find the solution with these dates. format ‘31 jan. 2025’ was logical (DD MMM. YYYY), it’s more complicated with ‘1 févr. 2025’ (DD MMM?? 2025), and I have still not identified how to process these two dates in different formats in the same flow. Any help is really welcome! ---
**Author:** ![Thierry](https://avatars.discourse-cdn.com/v4/letter/t/65b543/32.png) [@Thierry](https://community.make.com/u/Thierry)\ **Post date:** [February 4, 2025, 8:37am UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/10 "2025-02-04T08:37:31Z")
I get stuck with a date format. The first is ok ‘31 jan. 2025’ (DD MMM. YYYY), the second gives me a problem ‘1 févr. 2025’ (DD MMM ?? 2025), and the question I ask myself is how to process these two dates with these different formats in the same flow. Any help is really welcome! ---
**Author:** ![Joey\_R](https://avatars.discourse-cdn.com/v4/letter/j/ccd318/32.png) [@Joey\_R](https://community.make.com/u/Joey_R)\ **Post date:** [February 4, 2025, 9:02am UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/11 "2025-02-04T09:02:36Z")
If you’re parsing them in code, you need to standardize the format first. In Python, you can use locale or manually map month names before parsing. In JS, toLocaleDateString() with a fixed locale works. What’s your setup? ---
**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:** [February 17, 2025, 1:15pm UTC](https://community.make.com/t/convert-a-text-format-to-a-specific-date-format/68008/12 "2025-02-17T13:15:41Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.