defHLT/Insert current date in Google Spreadsheets

## Insert current date in Google Spreadsheets
// Insert current date in Google Spreadsheet
function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or FormApp or SpreadsheetApp.
  ui.createMenu('Custom Menu')
      .addItem('Insert Date', 'insertDate')
      .addToUi();

}

function insertDate() {
  var cell = SpreadsheetApp.getActive().getActiveCell();
  if (cell) {
      var d = new Date();
      var dd = d.getDate();
      dd = pad(dd, 2)
      var mm = d.getMonth() + 1; //Months are zero based
      mm = pad(mm, 2)
      var yyyy = d.getFullYear();
      var date = dd + "-" + mm + "-" + yyyy;
      var element = cell.setValue(date);
    } else {
      SpreadsheetApp.getUi().alert('Cannot get active cell.');
  }

}
function pad (str, max) {
  str = str.toString();
  return str.length < max ? pad("0" + str, max) : str;
}