Google-apps-script – Google Docs date capitalisation script

dateformattinggoogle docsgoogle-apps-script

I'm using a script that was posted here on Web Applications: Is there a way to insert today’s date into a Google Docs?. I changed the way the date is formatted to: ddMMMyyyy but want 01JAN2015 – the month being capitalized.

Currently my script reads and outputs like 01jan2015.

How do I capitalize the date?

Best Answer

Change this

var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy");

into this

var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy").toUpperCase();

ht to Chris

Code

var curDate = Utilities.formatDate(new Date(), "GMT+1", "MM/dd/yyyy")

References

Google Sheets Script – Add a Month to a Date

The issue here is on JavaScript level, not specific to Apps. The method setMonth that you use modifies the date object on which it's called. You don't need any assignment on that line. MDN docs don't even say what setMonth is supposed to return, but apparently it returns the millisecond timestamp corresponding to the new date. In any case, this is what works:

function myFunction() {
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet = spreadsheet.getSheetByName('Sheet1');
  var value = sheet.getRange('B2').getValue();
  var a1date = value.getMonth();
  value.setMonth((a1date+1) % 12);   // no assignment needed; also, mod 12
  sheet.getRange('B4').setValue(value); 
}

Notice that % 12 is needed to get from December to January.

Best Answer

Related Solutions

Google-sheets – How to format the date in this Google Apps Script

Code

References

Google Sheets Script – Add a Month to a Date

Related Topic