Thursday, November 22, 2018

Create a Search of Cases Created on a Certain Time Frame

 To create the search, perform the following steps:


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

2. Select Case.

3. Provide a Search Title.

4. In the Criteria tab > Standard subtab, add the filters:

  • Incident Date is within This Month
  • Formula (Numeric)

Formula = CASE WHEN (TO_NUMBER(TO_CHAR({startdate}, 'HH24')) < '7') THEN 1 ELSE 0 END | Value = 1

5. Click Save & Run.

No comments:

Post a Comment