Google Calendar events are created in UTC even with time zones set

Questions
1

:bullseye: What is your goal?

I’m using SmartSuite to pass a date for Make to create a Google Calendar All-Day event.

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

Despite having SmartSuite, Google Calendar, and Make are all set to the Pacific Time zone, events are created a day early. I’ve also tried forcing a time zone with the formatDate command in the event Start Date and End Date fields, but to no avail:

{{formatDate(4.S-Start-Date; DD - MM - YYYY; America / Los_Angeles)}}

:clipboard: Error messages or input/output bundles

The SmartSuite “Get a Record” module is outputting the correct start date of Aug 1 (although without Time Zone specified).

SmartSuite Output:

Bundle 1 Collection
    Id
    6931cb48550d7d224b1d1bc7
    Table Id
    6931cb48550d7d224b1d1a71
    Table Slug
    s11357gf
    Staging Date
    2025-08-01T00:00:00Z
    S-Start-Date
    2025-08-01T00:00:00Z
    S-End-Date
    2025-08-02T00:00:00Z
    PROJECT RECORD NAME
    5 Tuscany Court

However, the Google Calendar module is showing an input bundle with a start date of July 31 (even when I specify PT with formatDate):

Google Calendar input bundle:

Input

Bundle 1Collection
    End Date
    August 1, 2025 5:00 PM
    Start Date
    July 31, 2025 5:00 PM
    Create an Event
    detail
    Event Name
    S: 5 Tuscany Court
    Calendar ID
    c_d96cc46e27fa6fcd14a4e916777237c4fe3fe8b997078fb5d746d6ef74b0dac8@group.calendar.google.com
    Visibility
    default
    All Day Event
    true
    Show me as
    opaque
    Add Google Meet Video Conferencing
    false
    Guest PermissionsCollection

`

3

Your SmartSuite dates are stored as midnight UTC. When Make.com converts them to Pacific Time, they become 5 PM on the previous day, so Google Calendar shows the event 1 day early.

You can create the function for the Start Date like this:
{{ formatDate({{Start Date}}; “YYYY-MM-DD”; “UTC”) }}
{{ formatDate({{Start Date}}; “MM/DD/YYYY”; “UTC”) }}

You can create the function for the End Date like this:
{{ formatDate({{End Date}}; “YYYY-MM-DD”; “UTC”) }}
{{ formatDate({{End Date}}; “MM/DD/YYYY”; “UTC”) }}

1 Like
4

Thanks. I figured out that reformatting the date in a SmartSuite formula to eliminate the time portion of the date also works because it removes the timezone code from the end of the date.

2 Likes