Google Script Editor - Cannot find method formatDate(string,string,string)

Question

This was working yesterday and then just quit working today with the error "Cannot find method formatDate(string,string,string).". Any idea why this is going on?

var today = new Date();
sheetArchive.getRange('X3:X3').setValue(Utilities.formatDate(today, Session.getScriptTimeZone(), "yyyy-MM-dd HH:mm:ss")); // date submitted

Doesn't look like there's anything wrong there. Can you provide a minimal reproducible example? — Cooper
– Cooper, Commented Nov 7, 2017 at 5:33
Break up your chained code into multiple lines for debugging purposes. You can put it all back on one line after you've found the problem. It might be an incorrect error message. It could have been a temporary service disruption. It could be a bug. In any case, you'll need to get some more information. — Alan Wells
– Alan Wells, Commented Nov 7, 2017 at 12:55
Can replicate it too. Calling Utilities.formatDate(new Date(), x, y) works, Utilities.formatDate(today, x, y) fails with the same error message. — gingo
– gingo, Commented Nov 8, 2017 at 9:08
It was stupid syntax error in my case. I accidentally called method without parameter and passed this empty param as formatDate() first param. — gingo
– gingo, Commented Nov 8, 2017 at 9:16

shiri · Accepted Answer · 2018-01-22 00:50:35Z

2

Google must have had an error, I have not changed anything and then it started working again the next day.

edited Jan 22, 2018 at 0:50

shiri

7456 silver badges24 bronze badges

answered Nov 8, 2017 at 19:40

Brad Wickwire

1,1734 gold badges17 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Google Script Editor - Cannot find method formatDate(string,string,string)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related