I have a on call calendar that I use an event based view and it uses both day and time between each day. Each item starts at 8am and rotates weekly. I created a view that only shows the items with an end date that is greater than today which works great all the time except for the transition date between the hours of midnight and 8am. With this formula it move to the next shift and for 8 hours we are not displaying the right contact information. Is there a way to create a view that not only uses the end date but takes the end time into consideration as well?