Close popover
Craig Armstead (CraigA52)
Link Fund Solutions

Link Fund Solutions
CraigA52 Member since 2017 25 posts
Link Fund Solutions
Posted: November 6, 2018
Last activity: January 17, 2019

Report definition datetime not adjusting for DST

Hi All,

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?


Reporting User Experience
Moderation Team has archived post