Format / Parse Date from 10 September 2024 14:12

Hi guys,

I’m getting a date in this format as a string: 10 September 2024 14:12

I need to convert it to 2 fields:
Date: DD/MM/YYYY (10/09/2024)
Time: 14:12 (HH:mm)

I’m trying to format the string (first only the Date)

But getting an error that the string is not a valid date. I tried the same with ParseDate and the result is the same

What am I missing? :mag_right: :thinking:

1 Like

OK, while I’m still not sure how to solve the above problem, I realized the actual data comes in this format:

2024-09-09T08:32:20.000Z

and that is recognized by Make as a Date so all I need is to simply format it… :man_dancing:

1 Like

Hi @OmriNyx


Output:

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

2 Likes

Great @Msquare_Automation So my iniitial mistake not formatting the date correctly, it should be formatted like this as your example: {{parseDate(“10 September 2024 14:12”; “DD MMMM YYYY HH:mm”)}}

Where MMMM is the Full Month name representation :star_struck: :white_check_mark:

2 Likes