Wednesday, June 19, 2019

Create a Saved Event Search that will display Events created on Saturdays and Sundays

1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Select Event as your Search Type
3. In the Criteria tab, select Formula (Text) as your filter
4. Add the following formula in the Formula field:

CASE WHEN to_char({createddate},'D') in (1,7) then 'T' END and Formula (Text) is T

5. Click Save & Run

This search will now display all events created on Saturdays and Sundays.

No comments:

Post a Comment