I am new to Zapier and working on a Zap that reads incoming emails using the Email Parser; however, I am running into an issue if the appointment spans midnight. Unfortunately I do not have the duration of the appointment or the end date of the appointment, only the end time.
Looking for suggestions on how to calculate the time. My thought was along the lines of IF(‘Endtime’ < ‘Starttime’, ‘Resdate’ +1d, ‘Resdate’). This is easy enough in Excel but not finding a simple solution using the Zapier tools. I was unsuccessful in getting the Formatter to calculate as I am missing the data I need to extract.
Parser Output sample:
Parse Output Appttype: Hourly Rental
Parse Output Email: emailaddress@gmail.com
Parse Output Fname: Joe
Parse Output Lname: Smith
Parse Output Phone: 5555551212
Parse Output Resdate: Friday, May 31, 2024
Parse Output Starttime: 11:00 PM
Parse Output Endtime: 1:00 AM
The OUTPUT to the Create Record in Zapier Table returns the current date for the Endtime (testing date 5/27/24):
RESDATE: Friday, May 31, 2024
STARTTIME: 2024-06-01T06:00:00Z
ENDTIME: 2024-05-27T08:00:00Z
Any advice or assistance on how to handle this scenario would be greatly appreciated. Ideally I would like to calculate the duration of the appointment as this would make it simpler to create the calendar event following the create record in the Zapier Table and provide me with more flexibility to address appointment duration changes.
Thank you!
