Posted: 6 Nov 2018 2:57 EST Last activity: 17 Jan 2019 9:43 EST
Report definition datetime not adjusting for DST
We have a datetime field that's unfortunately stored as text (don't ask) that we use in one of our applications. When we display that field in a section it's correctly adjusted depending on the time of year, going from GMT to BST. However, we also have the same field in a report definition, but it isn't getting adjusted when ran.
So the date in question is this :- 20181025T080000.000 GMT
This should adjust to 20181025T090000.000 BST when viewed as that would have the correct time in October before the change in time. This happens correctly in the section but doesn't change when ran in a report. Both fields have the exact same property settings.
I've tried setting the column properties in the report to use pxDatetime which does change the output but doesn't adjust the time.
Any ideas what I need to alter to get this to work? Is this a bug?
That isn't a recognised function. I'm running Pega 7.31. Not only that but I'd created a new property that is datetime and copied the value across but even that field isn't taking the DST in to account.