I am using a Zap that creates a Google Calendar appointment from data originating in a Formsite form. Formsite has a date control, but no time control. I have created a time control using a list box. The date control outputs the date as “04/01/2020”. The time control outputs the time as “4:00pm”. I have another field that concatenates both controls to create a field with date in the format “04/01/20204:00pm”. The Zap works fine, when creating a detailed Google calendar appointment, except that Zapier creates a Calendar date with the wrong date and time. I have tried passing the fields singly and together. I have tried to use the Zapier Formatter application to convert the dates. Nothing seems to work. Can anyone Guide me step by step through getting the date and time in the proper format so that the correct date and time shows up on the Google calendar?
Best answer by jesse
View original