What is the process for converting and transferring the date in Google Apps Script to generate a new event in Google Calendar?

Question

What is the process for converting and transferring the date in Google Apps Script to generate a new event in Google Calendar?

To create an event in GAS, follow this link: https://developers.google.com/apps-script/reference/calendar/calendar#createEvent(String,Date,Date,Object)

var event = CalendarApp.getDefaultCalendar().createEvent('Apollo 11 Landing',
     new Date('July 20, 1969 20:00:00 UTC'),
     new Date('July 20, 1969 21:00:00 UTC'),
     {location: 'The Moon'});
 Logger.log('Event ID: ' + event.getId());

The input date format is (E, dd MMM yyyy HH:mm:ss Z) ..

When the output is separate date and time, like:

var bookTime, bookDate; // bookDate = 2014-11-26 and bookTime = 09    
var startDateTime  = bookDate + " " + bookTime+ ":00:00"; //startDateTime = 2014-11-26 09:00:00

If you have this time format, how can you use it to create an event?

Looking for any suggestions.

javascript date google-apps-script google-calendar-api

Answer 1

Answer №1

To work with starting values that are strings, one simple approach is to parse the values and construct a new date object with the appropriate parameters using string manipulation techniques. The following snippet demonstrates how this can be achieved with the provided data :

function testDate(){
  var date = createNewDate("2014-11-26", "09");
  Logger.log(date);
}

function createNewDate(dateString, timeString){
  var dateData = dateString.split("-");
  var hour = Number(timeString);
  var date = new Date(new Date().setFullYear(dateData[0], dateData[1]-1, dateData[2])).setHours(hour, 0, 0, 0);
  return new Date(date);
}

The resulting date object can be easily utilized in functions like calendar event creation.

Answer 2

To work with starting values that are strings, one simple approach is to parse the values and construct a new date object with the appropriate parameters using string manipulation techniques. The following snippet demonstrates how this can be achieved with the provided data :

function testDate(){
  var date = createNewDate("2014-11-26", "09");
  Logger.log(date);
}

function createNewDate(dateString, timeString){
  var dateData = dateString.split("-");
  var hour = Number(timeString);
  var date = new Date(new Date().setFullYear(dateData[0], dateData[1]-1, dateData[2])).setHours(hour, 0, 0, 0);
  return new Date(date);
}

The resulting date object can be easily utilized in functions like calendar event creation.

What is the process for converting and transferring the date in Google Apps Script to generate a new event in Google Calendar?

Answer №1

Similar questions

Assistance with themed implementation for single-page web applications in JavaScript

What steps should I take to ensure that elements beneath a div are made visible?

Issues with Bootstrap tabs loading jQuery and Ajax are preventing the proper functionality

Optimizing communication of time data in Laravel and Vue.js using Inertia

How to pass the Node environment to layout.jade in Express without explicitly specifying the route

Troubleshooting the unresponsive Vue @change event within the <b-form-datepicker/> component

Issue with AngularJS factory $http.get request receiving HTML files as response

Tips for successfully passing an object via a Link

Clicking an element to uncover more information

Tips for effectively utilizing node modules that have yet to be installed without encountering any errors

Able to display the value when printing it out, however when trying to set it in setState, it becomes

Generate and display a random element on a webpage using Javascript or jQuery on page refresh

curved edges and accentuate the chosen one

Can MUI FormControl and TextField automatically validate errors and block submission?

Error: Unrecognized error encountered while using Angularjs/Ionic: Property 'then' cannot be read as it is undefined

Best practices for sharing data between controllers in an Angular application

Cordova Application experiencing freeze on loading Splash Screen

I require assistance in displaying a dynamic, multi-level nested object in HTML using AngularJS

What is the best way to integrate jQuery Masonry with ES6 modules?

Adjust the aesthetic based on whether the field is populated or empty