google apps script convert string to object

Question

I have a question about the date convert: in sheet, I have a date '05/11/2018', I need to get next date 06/11/2018.

var end=Utilities.formatDate(new Date(coach_date.getTime()+1*3600000*24), 'GMT', 'dd/MM/yyyy');
var start = new Date();
var events = calendar.getEvents(start,end);

it shows the 'end' is string, not object. it has to be getEvents(object,object)

so I used end = new Date(end); it got '11/06/2018', change month from Nov to June.

How could I fix it, then use it on getevents() feature. Thanks a lot.

please mark as answered if that solved your issue.

JSmith
– JSmith

2018-11-04 01:51:55 +00:00
Commented Nov 4, 2018 at 1:51 — JSmith
– JSmith, Commented Nov 4, 2018 at 1:51

TheMaster · Accepted Answer · 2018-11-03 17:39:54Z

1

Utilities.formatDate() converts the date object into a string. So, use

var end = coach_date.setDate(coach_date.getDate()+1);

answered Nov 3, 2018 at 17:39

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

2 Comments

J.W. Over a year ago

TypeError: cannot call method "setDate" of undefined.(line 114, file "xxxx")

TheMaster Over a year ago

@J.W. define coach_date

Collectives™ on Stack Overflow

google apps script convert string to object

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related