Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function gantChart() {
- var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Copy of 2016 Gift Tracking");
- var values = ss.getRange(3,1,ss.getLastRow(),ss.getLastColumn()).getValues();
- var day = 24*3600*1000
- var today = parseInt((new Date().setHours(0,0,0,0))/day);
- var destSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Get chart automation");
- for (var i=0; i < values.length; i++) {
- var dataDay = parseInt(values[i][18].getTime()/day);
- if(dataDay > today) {
- }
- }
- debugger;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement