Wednesday, November 28, 2018

Search for Partner Records Created on Weekends or Weekdays

The user needs to generate a list of partners created during the weekends. The list can be generated by using the following steps:

1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Choose Type = Partner
3. On the Results tab, add a Formula (text) field with the following formula:

 For Weekends: 
 Case WHEN to_char({datecreated},'D') BETWEEN 7 AND 8 then 'T' END

 For Weekdays:
  Case WHEN to_char({datecreated},'D') not BETWEEN 7 AND 8 then 'T' END

4. Click Save & Run.

No comments:

Post a Comment