Monday, September 17, 2018

Include/Append the Day of the Week on a Date Field

To display in a saved search the day of the week when a date field falls, perform the following steps:

1. Navigate to Reports > Saved Searches > All Saved Searches.

2. Edit the Saved Search.

3. Click the Results tab > Columns subtab to add a Formula (Text) field.

4. Click the Set Formula icon.

5. On the field dropdown, select the date field.

For example:

 TO_CHAR ({createddate}, 'DAY - DD Mon')

6. Click Preview.

7. Result is MONDAY, June 07

Note: This is also applicable to other date fields:

     Incident Date:         {date} or {startdate}

     Date Closed:            {enddate}                                

     Last Message Date: {lastmessagedate}
     Last Modified Date:    {lastmodifieddate}
     Last re-opened Date:  {lastreopeneddate}

No comments:

Post a Comment