I have created a list of employees that are on call for certain portions of the day. For example: Employee A is on call 2019/04/11 0000-1500 hrs Employee B is on call 2019/04/11 1500-2359 hrs
I want the view to only show the person who is on call 'in the moment'. Using the [Today] function shows both employees regardless of what time someone is viewing the list - I would like just the employee that is 'currently on call' according to what the current time is to be displayed.
Any suggestions would be appreciated.