In BIX report , we have to show the many date time property in below format MM/dd/yyy hh:mm:ss. Initially I used date time property and used below formatdatetime function in pega but in bix generated report it shows the value in GMT format only. Then I changed property type from date time to text and used formatdatetime function but this time, also in gmt format.. Is there way we can show the date time property value in particular format and not in GMT. I guess by default BIX generated in GMT format but we want in particular format?

@FormatDateTime(.pxCreateDateTime,"MM/dd/yyyy hh:mm:ss","America/New_York","en_US")

@(Pega-RULES:DateTime).FormatDateTime(.pxCreateDateTime,"MM/dd/yyyy hh:mm:ss","America/New_York","en_US")