Convert a Text format to a specific Date format

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


Hi @Thierry
Date in this format will workfine:

Output:

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.

Output:

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

1 Like

Thank you. I test it right away!

1 Like

Hi @Thierry, Could you please mark the solution if it was helpful? It helps us keep the environment organized. Thank you!

4 Likes

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!

2 Likes

HIi @Thierry

Glad to know your issue is solved now.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes

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?

1 Like

Hi @Thierry, did you check our Make Academy article about Date and Time functions? Let me know, if it helps.

2 Likes

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!

1 Like

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!

1 Like

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?

1 Like