Question
TCS
IN
Last activity: 4 Aug 2025 0:27 EDT
BIX Time Date Column are showing in GMT format but we want to show it in MM/dd/yyy hh:mm:ss format.
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")
HCA Healthcare
US
@DeepakS4472
BIX always exports DateTime values in GMT, no matter how you try to format them using @FormatDateTime() in a rule or data transform. Even if you convert the DateTime to text, BIX still pulls the raw GMT value. To get around this, you need to create a separate Text property in your case (like FormattedCreateDate) and set its value using the @FormatDateTime() function with your desired format and timezone like "MM/dd/yyyy hh:mm:ss" and "America/New_York". You can set this value using a Declare Expression or Data Transform before the extract runs. Then, in your BIX extract rule, include this new Text property instead of the original DateTime. That way, BIX just reads the preformatted string and outputs it exactly as you want