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);

 }

question from:https://stackoverflow.com/questions/24894648/get-today-date-in-google-appscript

Answer 1

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
}