0

Here is my code:

function calEvent(){
   var arrivalDate = "06/10/2013";
   var departureDate = "06/18/2013";
   var start = new Date(arrivalDate);
   var end = new Date(departureDate);

   var cal = CalendarApp.getCalendarById('id487g3esn088a00omqa99ugv0@group.calendar.google.com');
   cal.createEvent('Apollo 11 Landing',start,end);

}

When I run this it will create the event in the correct calendar however it will only be from June 10 thru June 17. I need the event to cover June 10 - June 18.

I have checked the Timezone setting and the spreadsheet, script and calendar are all on the same time zone (Mountain Time GMT-7)

How can I get this seemingly simple code to set the event on the correct dates? I've tried several date formatting (utilities.formatDate) but can't seem to get the correct format.

Thanks in advance.

user2356785
  • 1
  • 1
  • 1
  • Can you confirm the calendar you are specifically requesting by ID is also in the right timezone? Can you try with `CalendarApp.getDefaultCalendar()` which is easier to see what TZ that is in. – Arun Nagarajan May 07 '13 at 12:48
  • Yes the calendar is set to the same Time Zone as the script and the spreadsheet. `CalendarApp.getDefaultCalendar()` won't work because I have 13 different calendars that I am using. – user2356785 May 07 '13 at 20:13

1 Answers1

1

How to use timeZone of calendar to set timeZone for date object

I posed the above question a couple a weeks ago, and came up with a working solution. Not sure if it is the best or not, but you can look over and see if it helps. In working on a solution for my question I noticed several things. The script definitely uses the script timezone to create a date object. But when it post to a calendar it adjust the date to executors default calendar timezone not the timezone of the calendar you're writing too. So if a user's default calendar timezone is different from the calendar being written to you will get all kind of crazy time's

So the function gasTimezoneOffset() that is listed in the above question was my solution for this.

Hope this helps.

Community
  • 1
  • 1
LennyZ71
  • 571
  • 4
  • 14