Question
2
Replies
126
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
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