Get Last Updated Date - Google Spreadsheet

lastUpdated

function onEdit() {
  Logger.log("Starting");
  var email = Session.getEffectiveUser().getEmail();
  Logger.log(email);

  var s = SpreadsheetApp.getActiveSheet();
  var r = s.getActiveCell();
  if( r.getColumn() != 2 ) { //checks the column
	  if( r.getRow() != 1 ) {
		var row = r.getRow();
		var time = new Date();
		time = Utilities.formatDate(time, "GMT-08:00", "MM/DD/yy");
		var formattedDate = Utilities.formatDate(new Date(),"GMT-04:00","MM-dd-yyyy 'at' HH:mm:ss z");
        Logger.log("formattedDate");
		SpreadsheetApp.getActiveSheet().getRange('K' + row.toString()).setValue(formattedDate);
        var email = Session.getActiveUser().getEmail();
        Logger.log(email);
        SpreadsheetApp.getActiveSheet().getRange('L' + row.toString()).setValue(email);
		};
  };
 };