I’m trying to reformat a date/time in one of my Zaps and I can’t figure out why it keeps coming out with the wrong data.
The trigger is an event booked in Calendly. That is being correctly received, in terms of when the event will take place (May 11th, 2022 at 10am)—
Here’s the rest of the set-up. My goal is to get it to come out as May 11 2022 10:00:00—
BUT, it keeps coming out with this, which I think is just spitting out TODAY’S date, and not May 11th, and I don’t see anything (at least myself) that I have incorrectly adjusted—
Does anyone see what I might be doing wrong?
Thanks in advance!
Best answer by Metagrate_John4manView original
Always best to set the From Format
Try specifying the From Format:
For the Input, don’t use “Event Start Time Pretty”. Use “Event Start Time” instead. (I believe that’s what it’s called, if not it should be similar.) I’m pretty sure Zapier will figure it out from there without having to specify the From Format.
You most likely also need to set From Time to US/Mountain.
Hope this helps!
Not worth screenshot’ing both to walk you thru each suggestion, because I just deleted the Step fully and then tried again.
Now I’m getting the right date, but not the right time…?! I tried UTC on both To and From and got the same result. BLERGH. Any additional thoughts?
@Brandi , I didn’t anticipate the Event Start Time would include the -06:00. Just change From Timezone back to UTC, but keep To Timezone US/Mountain.
The combo of those two things finally worked! Thanks, y’all!
Yay! Thanks so much for keeping the Community updated with what worked for you,