I am looking for a simple script to press a button or use a drop down to go to the current date. I am new to scripting and this problem is definitely showing that. I already have a menu item created.

I have tried this, but it is not doing anything. I’m not sure what the issue is, whether it is formatting or another issue.:

`function myFunction() {
  var ss = SpreadsheetApp.getActive();
  var sheet = SpreadsheetApp.getActiveSheet();
  var date = Utilities.formatDate(new Date(), 'GMT+5', 'dd/MM/yyyy');
  var ranges = sheet.createTextFinder(date).findAll().map(r => r.getA1Notation());
  sheet.getRangeList(ranges).activate();
}`