Thursday, December 20, 2018

Create a Saved Search that Displays Events Scheduled to Start within the Next 6 Hours

1. Navigate to Lists > Search > Saved Searches > New.
2. Select Event.
3. On the Criteria tab add Formula (Numeric).
a. Add Formula below:

case when {starttime} between {now} and ({now} + 6/24) then 1 else 0 end

b. Set Formula (Numeric) = equal to
c. Set Value = 1
6. Click Preview or Save & Run.


This displays Events that start within the next 6 hours.

No comments:

Post a Comment