Wednesday, March 13, 2019

Convert a date field to date with timezone format using a formula in a saved search

Steps:
1. Navigate to Lists > Search > Saved Searches > New.
2. Click Case.
3. Click Results tab.
4. Add Formula (Text) under Field column on Columns subtab.
5. Enter the formula below under Formula column:
TO_CHAR(TO_TIMESTAMP_TZ(TO_CHAR({createddate},'MM/DD/YYYY HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS TZH'),  'MM/DD/YYYY HH24:MI:SS TZH:TZM')
6. Click Save.

No comments:

Post a Comment