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

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 }