Question
2
Replies
132
Views
Posted: December 14, 2016
Last activity: December 20, 2016
Closed
Solved
Get values from DB/2 date columns with one day off
Hi,
I want to read date columns from a external database. The properties in the pxResult are always one day in the past. This happens with a date- or a text-property in the application.
Is there a fix for the problem?
With regards
Uwe
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Accepted Solution
Posted: 4 years ago
This article explains why you see one day off - https://pdn.pega.com/support-articles/report-shows-wrong-date-external-table-db2
convert it to the gmt while fetching and storing the data using expressions in expression builder