Script - Today's Date

function onOpen(){

SpreadsheetApp.getUi()
              .createMenu("Scripts")
              .addItem("Make Copy With Todays Date", "makeCopy")
              .addToUi();


};

function makeCopy() {

  var formattedDate = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");


  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var ss_id = ss.getId();

  DriveApp.getFileById(ss_id)
          .makeCopy(formattedDate.toString())

Comments