javascript - Why does my Date object in Google Apps Script return NaN - Stack Overflow

admin管理员组

文章数量:1341686

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: /

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/UTrYm/

• javascript
• datetime
• google-apps-script

Share Improve this question Follow edited Oct 19, 2018 at 16:16 Wicket 38.7k99 gold badges7979 silver badges194194 bronze badges asked Jul 13, 2011 at 18:40 citizen conncitizen conn 15.4k33 gold badges6161 silver badges8080 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 15

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").

Google apps script works fine when you use slashes instead of dashes. Like:

var date = new Date ('2017/12/26 9:55 am');
Logger.log(date);

本文标签： javascriptWhy does my Date object in Google Apps Script return NaNStack Overflow