citizen conn citizen conn - 3 months ago 28
Javascript Question

Why does my Date object in Google Apps Script return NaN

Does Google Apps Script use a funky version of EcmaScript that can't parse a date? How can I parse the date

2011-04-11T19:25:40Z
into a JavaScript Date Object in Google Apps Script?

My log output from below logs
NaN
.

function showDate(){
var d = Date.parse("2011-04-11T19:25:40Z");
Logger.log(d); // <-- Logs NaN
}


Edit: http://jsfiddle.net/UTrYm/

Answer

The format specified in section 15.9.1.15 is YYYY-MM-DDTHH:mm:ss.sssZ so maybe try adding milliseconds to your date format as in Date.parse("2011-04-11T19:25:40.000Z").

Comments