Tuesday, November 27, 2018

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

1.    Navigate to Lists > Search > Saved Searches > New

2.    Select Project

3.    Navigate to Results tab> Columns tab.

4.    Select Formula (Text) field

5.    On the Formula column in line with Formula (Text), set the value TO_CHAR({projectedenddate}, 'Day').

6.    Hit Add

7.    Select Preview or Save.

     Note: If day needs to be in uppercase letters, use the following formula: TO_CHAR({projectedenddate}, 'DAY')

 

No comments:

Post a Comment