Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. function gantChart() {
  2. var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Copy of 2016 Gift Tracking");
  3. var values = ss.getRange(3,1,ss.getLastRow(),ss.getLastColumn()).getValues();
  4. var day = 24*3600*1000
  5. var today = parseInt((new Date().setHours(0,0,0,0))/day);
  6. var destSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Get chart automation");
  7. for (var i=0; i < values.length; i++) {
  8. var dataDay = parseInt(values[i][18].getTime()/day);
  9. if(dataDay > today) {
  10. }
  11. }
  12. debugger;
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement