To create the search, perform the following steps:
1. Navigate to Lists > Search > Saved Searches > New.
2. Select Event.
3. Provide a Search Title.
4. In the Criteria tab > Standard subtab, set the required filters.
5. In the Results tab > Columns subtab, add Formula (Numeric) field.
6. In the Function field, select Round.
7. In the Formula field, use the formula below:
trunc(({startdate}-trunc({today}))/7)*5 + mod({startdate}-trunc({today}),7) - CASE WHEN to_number(to_char({startdate},'D')) < to_number(to_char({today},'D')) THEN 2 ELSE 0 END
8. Click Save and Run.
Note: This currently serves as an alternate solution for Enhancement Request #139186.
No comments:
Post a Comment