Google Apps Script: comparing dates

Question

I'm having a weird issue comparing dates in my Google Apps Script.

For this, my sheet has a date in cell.getValue() so on the

e.range.setNote(cell.getValue() + " --- " + startDate);

line, the note shows two dates that appear identical, but they aren't because the following if statement is not satisfied. Am I missing something here with the comparisons? Thanks.

function onEdit(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sss = ss.getSheetByName("Sheet1");

  var row = e.range.getRow();
  var startDate = sss.getRange(row, 3).getValue(); //Wed Aug 10 2016 00:00:00 GMT-0600 (GALT)

  var cell = ss.getSheetByName("Sheet2").getRange(1, 1);
  e.range.setNote(cell.getValue() + " --- " + startDate); //Wed Aug 10 2016 00:00:00 GMT-0600 (GALT) --- Wed Aug 10 2016 00:00:00 GMT-0600 (GALT)

  if (cell.getValue() === startDate){
      cell.setBackground('blue');
    }  

}

score 5 · Accepted Answer · edited May 23 '17 at 10:30

5

I think you need to compare as dates https://stackoverflow.com/a/493018/1393023

Replace

cell.getValue() === startDate

to

cell.getValue().getTime && startDate.getTime && cell.getValue().getTime() === startDate.getTime()

edited May 23 '17 at 10:30

Community

1
1

answered Aug 09 '16 at 22:17

contributorpw

4,739
5
27
50

1

Not sure why you have repeated conditions in your suggested edit but the getTime() method worked perfectly, thanks! – JoshM Aug 09 '16 at 22:37
2

`cell.getValue().getTime` and `startDate.getTime` check whether it is a date. – contributorpw Aug 09 '16 at 22:54

Google Apps Script: comparing dates

1 Answers1

Linked