Convert DATE from UTC to EST in RTF template pdf Report
I have created PDF report using RTF template, in backend I am using BI analysis and SQL queries in data model. There are many date fields in the report those are shown in UTC in final PDF eventhough in preferance I have set Timezone as 'EST' in BI Pub as well as application.
When I run BI Analysis there its showing expected timezone, same BI Analysis being used while generating report, but in report time is shown in UTC.
I eventhough tried below in RTF template, here time is not getting converted only timezone is changed.
<?format-date:CHANGE_HISTORY_DATE;'MM/DD/YYYY hh:mm a zzz';'EST'?>