Why does my Date object in Google Apps Script return NaN

Question

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/

Mike Samuel · Accepted Answer · 2016-08-22 14:35:09Z

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

edited Aug 22, 2016 at 14:35

answered Jul 13, 2011 at 18:48

Mike Samuel

121k30 gold badges230 silver badges255 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

citizen conn Over a year ago

That did it. Is there a reason why JSFiddle is able to parse it but Google Apps Script cannot?

Mike Samuel Over a year ago

@citizen conn, I believe Google Apps Script uses Rhino to interpret your JavaScript, whereas JSFiddle is using the interpreter built into your browser. Rhino is allowed to reject that input according to the spec but your browser's interpreter is being more permissive than the spec requires and not requiring milliseconds.

user3717023 Over a year ago

My reading of section 15.9.1.15 is that milliseconds could be omitted; the absent value should be interpreted as zero.

Mike Samuel Over a year ago

@NormalHuman, You're referring to the "one of the following time forms" verbiage? You're probably right then. Rhino was being overly strict.

Bryan Over a year ago

"was being overly strict" => "is being overly strict." 4 years later, this is still an issue. Thanks for the answer!

Howdy · Accepted Answer · 2017-12-27 17:36:14Z

0

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);

answered Dec 27, 2017 at 17:36

Howdy

6469 silver badges15 bronze badges

Collectives™ on Stack Overflow

Why does my Date object in Google Apps Script return NaN

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related