title: concatenate date and time in google spreadsheet
body: <p>I have a script that imports events from spreadsheets into calendar:</p>
  
  <pre><code>function caltest1() {
    var sheet = SpreadsheetApp.getActiveSheet();
    var startRow = 2;  // First row of data to process
    var numRows = 3;   // Number of rows to process
    var dataRange = sheet.getRange(startRow, 1, numRows, 5);
    var data = dataRange.getValues();
    var cal = CalendarApp.getDefaultCalendar();
    for (i in data) {
      var row = data[i];
      var title = row[0];  // First column
      var desc = row[1];       // Second column
      var tstart = row[2];
      var tstop = row[3];
      var loc = row[4];
      //cal.createEvent(title, new Date("March 3, 2010 08:00:00"), new Date("March 3, 2010     09:00:00"), {description:desc,location:loc});
      cal.createEvent(title, tstart, tstop, {description:desc,location:loc});
   }
  }
  </code></pre>
  
  <p>The script works fine if my spreadsheet contains the data like:</p>
  
  <pre><code>Title      Description    Start               Stop                  Channel
  Mr Dear    no drinks      5/6/2014 20:55:00   5/6/2014 21:57:00     what ever
  </code></pre>
  
  <p>But it does not work if I create my own date =CONCATENATE($D4, " ",$G4), given that D4 has a date and G4 has time combined into a single cell Date and time. I figured because it senses that concatenate creates a plain text and not a time formatting, but how can I fix it?</p>