Javascript - criteria date and loop date doesnt match
up vote
0
down vote
favorite
This is part of code. Rest of code works but on this part Ive stuck and I dont know why! function rndDATgen(F){ var fRNG = SpreadsheetApp.getActiveRange(); var fROW = fRNG.getRow(); var ss = SpreadsheetApp.getActiveSpreadsheet(); var SRCsheet = ss.getSheetByName("Dates"); var DSTsheet = ss.getActiveSheet(); var rngDATE = SRCsheet.getDataRange(); var valDATE = rngDATE.getValues(); var colSRNG = DSTsheet.getRange('A1:ZZ7'); var colVALUES = colSRNG.getValues(); var stDAT = DSTsheet.getRange("S1").getValue(); var enDAT = DSTsheet.getRange("S2").getValue(); var DSTclr = 7; var DSTrow = 7; var nDAT = 0; var DSTlr = 7; var DSTc = DSTsheet.getRange(1, 9, 500,1); var DSTvalues = DSTc.getValues(); while (DSTvalues[DSTlr - 1][0] != ""){ ...