QA Tips – Display Time in 12/24 Hours Clock Format

To display the time in 12 hours or 24 hours clock format, follow the steps below:

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

2. Select the entity record type.

3. Under the Criteria tab select the desired filters.

4. Under the Results tab select the desired fields then include a Formula (Text) field and enter the following in the FORMULA field:

  • TO_CHAR({datecreated},’MM/DD/YYYY HH24:MI:SS’)
  • For a 12 – Hour Clock format the formula is: TO_CHAR({datecreated},’MM/DD/YYYY HH:MI:SS’)

5. Click Save & Run or Preview.

Leave a comment

Your email address will not be published. Required fields are marked *