I need to format the date from Google Calendar (2024-12-18T08:30:00-03:00) to ISO 8601 Calendly (2024-12-18T11:45:00Z or 2024-12-18T11:45:00+00:00).
I've been trying with Zapier Formatter in many ways and always fails.
How can I do it?
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
I believe your input date is already in the ISO format.
Here's the breakdown:
2024-12-18: Date in YYYY-MM-DD format.
T: Separator between date and time.
08:30:00: Time in HH:MM:SS format (24-hour clock).
-03:00: Timezone offset, indicating 3 hours behind UTC
The formatted datetimes you are entering are wrong because the -0000 offset is invalid. To correct this the the offset should be -00:00. Although this will be different from your input timezone of -03:00 or three hours behind UTC.
To convert to UTC just add a Z at the end 2024-12-18T11:30:00Z or format the offset as -00:00
Another issue is that the meeting is 15 minutes long but your start and end are the same time your end datetime should read 2024-12-18T11:45:00-03:00 15 minutes after the start.
Do let me know if I understood the problem correctly.
I believe your input date is already in the ISO format.
Here's the breakdown:
2024-12-18: Date in YYYY-MM-DD format.
T: Separator between date and time.
08:30:00: Time in HH:MM:SS format (24-hour clock).
-03:00: Timezone offset, indicating 3 hours behind UTC
The formatted datetimes you are entering are wrong because the -0000 offset is invalid. To correct this the the offset should be -00:00. Although this will be different from your input timezone of -03:00 or three hours behind UTC.
To convert to UTC just add a Z at the end 2024-12-18T11:30:00Z or format the offset as -00:00
Another issue is that the meeting is 15 minutes long but your start and end are the same time your end datetime should read 2024-12-18T11:45:00-03:00 15 minutes after the start.
Do let me know if I understood the problem correctly.
Thanks for the answer.
Yeah, you’re right, but this is only one of the many solutions I tried. I also try using the G Calendar raw date format, and input manually and problem still there.
For us to have full context, post screenshots showing how your current Zap steps are outlined and configured in EDIT mode with the field mappings visible.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.