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. For this example let us use Customer.
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')

Note: For a 12 - Hour Clock format the formula is: TO_CHAR({datecreated},'MM/DD/YYYY HH:MI:SS')

5. Click Save & Run or Preview.