I am getting the data from the webhook in this format “1:00 PM”, “2:30 PM”. But further in the automation I need to use the time in the format “13:00” and “14:30”
- I didn’t find how to do it with Date/Time functions, maybe there is some module?
I created a little formula that helped me with this.
{{if(contains(1.appointment.only_end_time.string; “AM”); 0 + first(split(1.appointment.only_end_time.string; space)); (parseNumber(first(split(first(split(1.appointment.only_end_time.string; space)); “:”))) + parseNumber(12)) + “:” + last(split(first(split(1.appointment.only_end_time.string; space)); “:”)))}}
It’s not perfect, because it doesn’t work from 12:00 AM, but in my case it’s enough.
There is a “format date” function. Use function in here: formatDate(your.variable; HH)
Use this document for further reference.
Princy Jain
Make consultant,
For consulting support: Follow up Automated
2 Likes
According to the Tokens you can use to parse a date variable, you can use h:mm A.
According to the Tokens you can use to format a date variable, you can use HH:mm.
e.g.:
{{ formatDate(parseDate(1.appointment.only_end_time.string; "h:mm A"); "HH:mm") }}
1:00 PM
12:00 AM
12:00 PM
For more information, see
Links
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate ← CHECK THIS OUT
- Make Blog – get the latest updates
- Features & Pricing
Help Center Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Tokens for
parseDate| Tokens forformatDate← CHECK THIS OUT - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI
- How to use Regex in Make
3 Likes