Set a criteria filter on the saved search using a formula.
1. Navigate to Lists > Search > Saved Searches > New.
2. Select Transaction.
3. In the Criteria tab > Standard subtab, add Formula (Text).
4. In the Popup window, use the formula below:
Case WHEN to_char({datecreated},'HH24') >= 17 AND to_char({datecreated},'D') between 2 AND 6 then 'T' END
Note: This lists all transactions created after 5PM during weekdays (M-F)
5. In the Formula (Text) field, select IS then enter T in the textbox.
6. Click Set.
7. Click Save & Run.
No comments:
Post a Comment