I'm having issues with the date format when transferring information from Google Sheets to Google Calendar

When setting up the dates, it switches the day with the month and creates events with incorrect duration. How can I change the date format so that the output is correct?


Is Marca Temporal the date that you are using in Google Calendar?

Trying parsing the date first in the Google Calendar Start/End Date using the following formula,

{{parseDate("3/2/2023 19:57:39"; "D/M/YYYY HH:mm:ss")}}

Switch D with M if the first section is month instead of Date.