OmriNyx
September 9, 2024, 7:10am
1
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?
1 Like
OmriNyx
September 9, 2024, 8:37am
2
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…
1 Like
Hi @OmriNyx
Output:
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
2 Likes
OmriNyx
September 10, 2024, 4:55am
4
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
2 Likes