Get today date in google appScript

Question

How do I get the Today date on google appscript   I need to write a code to input today  s date in a cell   function changeDate      var sheet   SpreadsheetApp getActiveSpreadsheet   getSheetByName GA CONFIG     var date     Today  s date          var endDate   date     sheet getRange 5  2  setValue endDate

User · Accepted Answer

Utilities formatDate new Date     GMT 1    dd MM yyyy     You can change the format by doing swapping the values    dd   day 31  MM   Month 12  - Case sensitive yyyy   Year 2017    function changeDate         var sheet   SpreadsheetApp getActiveSpreadsheet   getSheetByName GA CONFIG          You could use now Date    on its own but it will not look nice      var date   Utilities formatDate new Date     GMT 1    dd MM yyyy       var endDate   date

User · Answer

The following can be used to get the date   function date date     var date   new Date    var year   date getYear    var month   date getMonth     1   if month toString   length  1  var month     0  month   var day   date getDate    if day toString   length  1  var day    0  day   var hour   date getHours    if hour toString   length  1  var hour    0  hour   var minu   date getMinutes    if minu toString   length  1  var minu    0  minu   var seco   date getSeconds    if seco toString   length  1  var seco    0  seco   var date   year      month      day      hour      minu      seco  Logger log date

User · Answer

The Date object is used to work with dates and times   Date objects are created with new Date    var now   new Date      now - Current date and time object   function changeDate         var sheet   SpreadsheetApp getActiveSpreadsheet   getSheetByName GA CONFIG       var date   new Date        sheet getRange 5  2  setValue date

User · Answer

Google Apps Script is JavaScript  the date object is initiated with new Date   and all JavaScript methods apply  see doc here

User · Answer

function myFunction       var sheetname    DateEntry    Sheet where you want to put the date   var sheet   SpreadsheetApp getActiveSpreadsheet   getSheetByName sheetname          You could use now Date    on its own but it will not look nice    var date   Utilities formatDate new Date     GMT 5 30    yyyy-MM-dd          var endDate   date      sheet getRange sheet getLastRow     1 1  setValue date     Gets the last row which had value  and goes to the next empty row to put new values

[google-apps-script] Get today date in google appScript

Examples related to google-apps-script