lundi 11 mai 2020

Compare data with present date google script

Hi i want to compare column with date (i.e "Referral Date" column) image of column with present day , here is what i have

function newF(){
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Worksheet');
var range = ss.getDataRange();
  var headers = range.getValues()[0];
  var colIndex = headers.indexOf("Referral Date");
  var today = new Date();
var searchRange = ss.getRange(2,colIndex+1,ss.getLastRow()-1);
for (i=0;i<range.getLastRow();i++){
  var dates = searchRange.getValues();
      if (today.valueOf()>dates.valueOf()){
        updatelFilter()
      } else{
        SpreadsheetApp.getUi().alert('Future Date Error');
      break;
    }
  }
}

The problem i have is, it throws alert Future Date Error irrespective of date in column (Referral Date). Let me know if additional information is required.

My goal:

1)if date column (Referral Date) is greater than present date : Throw alert error & should not run updateFilter

2)if (Referral Date) is lesser than present date: Run updateFilter function

Aucun commentaire:

Enregistrer un commentaire