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

How To
1

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?

thanks

Captura de Pantalla 2023-03-28 a la(s) 20.42.06
Captura de Pantalla 2023-03-28 a la(s) 20.42.061920×1094 126 KB

Captura de Pantalla 2023-03-28 a la(s) 20.42.34
Captura de Pantalla 2023-03-28 a la(s) 20.42.341920×1076 115 KB

2

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.

3 Likes