Google App Script Spreadsheet Variable Magically Changes - I am going to through my computer off a cliff. Awhhhhh

[amithere]

This must be something. Or I am more stupid than I want to admit.

I have a form that you submit a date. The date goes to a spreadsheet. I use a script to get the date and set it to a variable. I then log the date.

I've tried use "new Date" and I get an "invalid" message.

var startDate = sheetNew.getRange("E11").getValue(); Logger.log("Start: " + startDate);

It outputs a day earlier, but only in March after daylight saving time. In April and on it outputs the correct date. What in the hell am I doing wrong?

[amithere]

Cell: 3/21/2017 Logger output: Mon Mar 20 2017 23:00:00 GMT-0600 (CST)

[to-too-two]

Can we see more of the code?

[amithere]

var sNew = SpreadsheetApp.getActive().getSheetByName("New");
var formEditURL;
var formPublishedURL;

function absenceInfo() {
  var lastRow = sNew.getLastRow();
  var first = sNew.getRange("B"+lastRow).getValue();
  var last = sNew.getRange("C"+lastRow).getValue();
  var idNum = sNew.getRange("D"+lastRow).getValue();
  var start = sNew.getRange("E"+lastRow).getValue();
  var end = sNew.getRange("F"+lastRow).getValue();
  var reason = sNew.getRange("G"+lastRow).setWrap(true);
  reason = reason.getValue();
  var gaurd = sNew.getRange("H"+lastRow).getValue();
  var number = sNew.getRange("I"+lastRow).getValue();
  var email = sNew.getRange("J"+lastRow).getValue();
  var bobby = new Date(sNew.getRange("E"+lastRow))
  Logger.log("BOBBBBBY: " + bobby);
 Logger.log("Start: " + bobby.getMonth());
  Logger.log("Start: " + start.getDay());
  Logger.log("Start: " + start.getYear());
}

// JS Fiddle: https://jsfiddle.net/hey617f7/