Saturday, September 15, 2018

Remove Time Stamps on Date Fields Used for Saved Search

 Customize the search and use a Formula (Date) field.
     1. Navigate to Reports > Saved Searches > All Saved Searches > New.
     2. Select Case.
     3. Provide a Search Title.
     4. Click the Results tab > Columns subtab.
     5. Add Formula (Date).
     6. In the formula field, click the Set Formula icon.
     7. In the Field dropdown list, select the date field (e.g. Last Modified Date).
     8. Click Set.
     9. Click Preview.

This is also applicable to other date fields:

  • Date Created:          {createddate} or {date}
  • Date Closed:                  {enddate} or {closed}
  • Last Message Date:  {lastmessagedate}
  • Incident Date:          {date} or {startdate}
  • Last Modified Date:   {lastmodifieddate}
  • Last re-opened Date:{lastreopeneddate}

Note: Enhancement 91168 has been filed to have the  ability to change the format of Date on Saved Searches to show only Date not the Date and Time Stamp.

No comments:

Post a Comment