Exception: The parameters (String,String,(class)) don't match the method signature for CalendarApp.Calendar.createAllDayEvent.

[Amietee Fuondjing]

Can someone tell me what is wrong? I keep getting that exception.

function scheduleEvent()

{

// Open the event calendar

var spreadsheet = SpreadsheetApp.getActiveSheet();

var calendarId = spreadsheet.getRange("A2").getValue();

var eventCal = CalendarApp.getCalendarById(calendarId);

// Pull each event into code

var events = spreadsheet.getDataRange().getValues();

// Fill in event details by column

for (x=3; x<events.length; x++)

{

var col = events[x];

var eventName = col[0];

var startDate = col[1];

var endDate = col[2];

var loca = col[3];

var descr = col[4];

if (startDate.valueOf() == endDate.valueOf())

{

eventCal.createAllDayEvent(eventName, startDate, {location: loca, description: descr});

}

else

{

eventCal.createAllDayEvent(eventName, startDate, endDate, {location: loca, description: descr});

}

}

}

[dimud...@gmail.com]

Your startDate and endDate variables are Strings, when they should be Date instances.

See documentation for proper usage:

https://developers.google.com/apps-script/reference/calendar/calendar#createAllDayEvent(String,Date,Date,Object)

https://developers.google.com/apps-script/reference/calendar/calendar#createAllDayEvent(String,Date,Object)

[Amietee Fuondjing]

Do you mind explaining how there are strings? When I pull the data from the spreadsheet the date columns (col[1], col[2]) are in the date format.

[Florin Ciobanu]

Use  eventCal.createEvent(eventName, new Date(startTime), new Date (endTime)) to convert string to date