Guest User

Untitled

a guest
Jul 17th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. var ss = SpreadsheetApp.getActiveSheet();
  2. var dateRange = ss.getRange(2,7).getValue(); // Value in Cell G2 is "7/17/2018"
  3. Logger.log(dateRange); // Returns Mon Jul 16 20:00:00 GMT-04:00 2018
  4. Logger.log(Utilities.formatDate(new Date(dateRange), Session.getScriptTimeZone(), "yyyy-MM-dd"));// returns 2018-07-16
  5.  
  6. var ss = SpreadsheetApp.getActiveSheet();
  7. var dateRange = ss.getRange(1,2).getValue(); // Value in Cell B1 is "7/17/2018"
  8. Logger.log(dateRange); // Returns Tue Jul 17 00:00:00 GMT-04:00 2018
  9. Logger.log(Utilities.formatDate(new Date(dateRange), Session.getScriptTimeZone(), "yyyy-MM-dd")); // Returns 2018-07-17
Add Comment
Please, Sign In to add comment