parseDate formula for Google Calendar Start Date — date format from email not working

Questions
1

:bullseye: What is your goal?

Create a calendar invite in Google Calendar when an email is received.

:thinking: What is the problem & what have you tried?

Hi everyone,

I’m building a scenario that watches Gmail for Viator booking confirmation emails and creates Google Calendar events. Everything is working except the Start Date field in the Google Calendar module.
My Text Parser modules are extracting these values successfully:

Travel date (module 15): Jul 16, 2026
Time (module 16): 10:00

In the Google Calendar Start Date field I’m trying to combine them into a valid date. I’ve tried all of these without success:

formatDate(parseDate(15.$1 & " " & 16.$1; “MMM d, yyyy HH:mm”); “YYYY-MM-DDTHH:mm:ss”)
formatDate(parseDate(15.$1 & " " & 16.$1; “MMM dd, yyyy HH:mm”); “YYYY-MM-DDTHH:mm:ss”)
formatDate(parseDate(15.$1 & " " & 16.$1; “EEE, MMM d, yyyy HH:mm”); “YYYY-MM-DDTHH:mm:ss”)

Each attempt gives me a variation of “couldn’t parse a valid date” or “invalid date in parameter start.”

What is the correct formula to combine Jul 16, 2026 and 10:00 into a valid Google Calendar start date?

Thanks!

:clipboard: Error messages or input/output bundles

A required field is empty or in the wrong format
Validation failed for 1 parameter(s).

Invalid date in parameter ‘start’.

Code: BundleValidationError

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Screenshot 2026-07-17 at 00.52.57.pdf (388 KB)

2

Hello,
I assume results from module #15 and #16 are strings, not dateTime?

If so, you must parse each date and then combine them to RFC3339 required by Google.

One of possible solutions:

  1. Parse module 15 output using:
{{formatDate(parseDate(2.module15; "MMM DD, YYYY"); "YYYY-MM-DD")}}
  1. Parse module 16 output using:
{{formatDate(parseDate(2.module16; "HH:mm"); "HH:mm:ss")}}
  1. Combine them to RFC3339:
{{parseDate(3.parseDate + "T" + 3.parseTime; "YYYY-MM-DDTHH:mm:ss")}}

These functions can be nested, Set Multiple Variables is added in the example to help you understand what’s going on.

Example scenario:

Another approach is to use setHours and setMinutes.

Please treat my response only as one of many possible solutions - I know only a limited part of your workflow and can’t guarantee that’s the best solution for your use case.

Have a nice day,
Michal

3

I CANNOT THANK YOU ENOUGH :folded_hands::folded_hands::folded_hands::folded_hands:
This worked perfectly and beautifully.

Thank you soooooooooooo much.

The hours I spent trying to figure it out with AI :robot::sweat_smile:.

Thank you, thank you, thank you!