Monday, September 3, 2018

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

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