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