SharePoint calendar -need to display only today’s events

I have a calendar to track employee whereabouts. Sometimes the events can span over multiple days. On a “status board” page, I need there to be a view of the calendar to only display events occurring today.

I’ve tried using the filer where Start Time is less than or equal to [Today] AND where End Time is greater than or equal to today.

It is still showing future events. Any suggestions for me?

Jump to today’s date when opened

I have found a similar question here:
How to make Google Sheet jump to today's column when opened?

I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several times to make it work by doing some changes, either in the first than in the second script, but it didn’t work. I’m really new, so I suppose the solution is easy, but unfortunately, I am not able to solve it by myself.

The code in the question I quoted is this:

function onOpen() {     var ss = SpreadsheetApp.getActiveSpreadsheet();     var sheet = ss.getActiveSheet();     var range = sheet.getRange("A:A");     var values = range.getValues();     var day = 24*3600*1000;     var today = parseInt((new Date().setHours(0,0,0,0))/day);     var ssdate;     for (var i=0; i<values.length; i++) {         try {             ssdate = values[i][0].getTime()/day;         }         catch(e) {         }         if (ssdate && Math.floor(ssdate) == today) {             sheet.setActiveRange(range.offset(i,0,1,1));             break;         }     } } 

Please, can someone help me?

Jump to today’s date + offset 10 rows

New to scripting. Have a planner in Google sheets which is displayed on a monitor in the office. I have a script to make it jump to today’s date on open (found here). The planner is organized with 1st of January on top, 31st of December bottom.

I want to make the sheet open to today’s date +10 (row), like an offset if possible.

Script:

function onOpen() {  var ss = SpreadsheetApp.getActiveSpreadsheet();  var sheet = ss.getActiveSheet();  var range = sheet.getRange("B:B");  var values = range.getValues();    var day = 24*3600*1000;    var today = parseInt((new Date().setHours(0,0,0,0))/day);    var ssdate;   for (var i=0; i<values.length; i++) {    try {      ssdate = values[i][0].getTime()/day;    }    catch(e) {    }    if (ssdate && Math.floor(ssdate) == today) {      sheet.setActiveRange(range.offset(i,0,1,1));      break;    }      } }