Display the Day of the Project's Projected End Date in a Saved Search

Scenario

Users need to display the day of the Project's Projected End Date in a saved search.

Solution

1. Navigate to Lists > Search > Saved Searches > New
2. Click Project or Job
3. On the Result tab, under Columns subtab:
4. Add a field called Formula (Text)
   1. • Copy the formula: TO_CHAR({‌projectedenddate}, 'Day')
        NOTE: If the day needs to be in uppercase letters, use the formula below instead: TO_CHAR({‌projectedenddate}, 'DAY')
      • Click Add button
5. Click Save
6. Click Save & Run to save and see the results