Reformatting date from Google Sheets form

Question

I'm using Google Forms to submit data into a Google Sheet. When I log the cell value which contains the date, it returns "Thu Apr 22 03:00:00 GMT-04:00 2021"

I want the date to look like "April 22, 2021"

Any advice on how to accomplish this? Any hints would be appreciated.

Thank you.

Utilties.formatDate(new Date('Thu Apr 22 03:00:00 GMT-04:00 2021'),Session.getScriptTimezone(), "MMM dd, yyyy"); or you could probably format the cell with the spreadsheet formatting tools. — Cooper

doubleunary doubleunary · Accepted Answer · 2021-04-22T17:27:51

Follow @MetaMan's advice and use Utilities.formatDate(). The timezone should be set to that of the dates you receive from the spreadsheet, because the script may be in a different timezone:

function logFormResponseDates() {
  const ss = SpreadsheetApp.getActive();
  const dates = ss.getSheetByName('Form Responses 1')
    .getRange('A2:A').getValues().flat().filter(String);
  const timezone = ss.getSpreadsheetTimeZone();
  const formattedDates = dates.map(date => Utilities.formatDate(date, timezone, 'mmmm d, yyyy'));
  console.log(JSON.stringify(formattedDates));
}

Reformatting date from Google Sheets form

1 Answers