Convert time

How To
1

Hey there,

i need help with converting a date & time from this:

  1. August 2024 06:44

to this:
2024-08-22T06%3A44%3A00%2B01%3A

Can anyone help?

Best regards, Jane

1 Like
3

Give this a try:

image
image2310×832 140 KB

{{parseDate(<field>; "DD. MMMM YYYY HH:mm")}}

Some info on parseDate syntax is at:

https://www.make.com/en/help/functions/tokens-for-date-time-parsing

4

Hi @Jane_Slaar
Try the below method to achieve this.
{{replace(replace(formatDate(now; “YYYY-MM-DDTHH:mm:ssZ”); “:”; “%3A”); “+”; “%2B”)}}
image

Output:
image

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

4 Likes
5

Thanks @Msquare_Automation

I tried a similar rule, but for some reasons, that didn’t work.

Your solution is working :slight_smile:

2 Likes
6

@Jane_Slaar

Glad to know your problem is resolved and appreciate your feedback.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation