Question

2
Replies
72
Views
CraigA52 Member since 2017 24 posts
Link Fund Solutions
Posted: 1 year ago
Last activity: 1 year 9 months ago
Closed

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?

Thanks

Reporting User Interface
Moderation Team has archived post
Share this page LinkedIn