You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert DATE from UTC to EST in RTF template pdf Report

Summary:

Hi All,


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'?>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!