function trigger() { const today = new Date(); const timezone = "America/Los_Angeles"; // get the timezone or you can harcdode it for exemple "GMT-5" const todayFormatted = Utilities.formatDate(today,timezone,"MM/dd/YYYY"); const hour = Utilities.for...

so, in the first place I see that you take a range of 2 columns "A2:B29" at line 10. (Maybe you are 2 columns with dates ?)You have to check if you are the good format in your sheet for these columns: Format > Number > DateAt line 14 you can replace ...

can you share your script ? 

function trigger() { const today = new Date(); const timezone = today.toString().match(/([A-Z]+[\+-][0-9]+)/)[1]; // get the timezone or you can harcdode it for exemple "GMT-5" const todayFormatted = Utilities.formatDate(today,timezone,"dd/MM/YYYY");...

function trigger() { const today = new Date() const todayFormatted = Utilities.formatDate(today,"GMT+2","dd/MM/YYYY"); const hour = Utilities.formatDate(today,"GMT+2","HH"); const isGoodHoursRange = hour >= 10 && hour < 17 const dateList = Spreadshee...