google apps scripts date formatting

Question

I'm having trouble with something that should be very simple - just creating a Date() in Google Apps Script (javascript)

var thisdate = new Date('2017-02-12');
Logger.log(thisdate.toString());

This test results in 'Invalid Date'... I must be missing something really obvious!?

Thanks

Possible duplicate of [Google Apps Script date format issue (Utilities.formatDate)](http://stackoverflow.com/questions/28956532/google-apps-script-date-format-issue-utilities-formatdate) — Deep 3015, Feb 18 '17 at 13:34

score 1 · Accepted Answer · answered Feb 18 '17 at 14:13

Unfortunately, a date string in the format of '2017-02-12' won't work in Apps Script, even though it should be a valid JavaScript date string. You can replace the dashes with slashes, and it will work.

var d,string;

string = '2017-02-12';

if (string.indexOf("-") !== -1) {//A dash was found in the date string
  string = string.replace(/-/g,"/");//Replace dashes with slashes
  Logger.log(string)
  d = new Date(string);
} else {
  d = new Date(string);
}

Logger.log(d)

Thanks very much - how strange that it doesn't support the ISO date format! — user2343854, Feb 18 '17 at 15:03

score 1 · Answer 2 · answered Feb 18 '17 at 22:58

You can pass the numbers, separated by comma, as arguments to the Date object constructor.

var d = new Date(2017, 2, 12); //year, month, date.

The months start with 0, so 2 is actually March. In the example below, the output for month will be 3

  Logger.log(Utilities.formatDate(d, timezone, "dd-MM-yyyy"));

google apps scripts date formatting

2 Answers2

Linked