Google Apps Script date format issue (Utilities.formatDate)
The Utilities.formatDate() utility formats a javascript String. However, when written out to the spreadsheet, the new row of data is interpreted by Google Sheets to determine data types and appropriate formatting, just as if you’d typed it in through the user interface. Since you’ve got a recognizable date string, Google Sheets decides it’s a Date, … Read more