Display Cases Created Between 5:00 PM Friday to Sunday 5:00 PM

1. Navigate to Lists > Search > Saved Searches > New.

2. Select Case.

3. Provide a Search Title.

4. Under Criteria tab, add Formula (Numeric) and use below formula:

CASE WHEN (TO_CHAR({createddate},'D')=6 AND TO_CHAR({createddate},'HH24') >= 17) OR  (TO_CHAR({createddate},'D')=7) OR (TO_CHAR({createddate},'D')=1 AND TO_CHAR({createddate},'HH24') <= 17) THEN 1 ELSE 0 END

Formula (Numeric) = Equal to

Value = 1

5. Click the Results tab and add fields as needed.

6. Click Save & Run.