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.
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