Invalid datetime format: pxUpdateDateTime
Hi,
On our production environment on 7.3 we run into an issue when scheduling a report with a simple filter condition that the .pxUpdateDateTime equals Yesterday and the .pxUpdateDateTime != .pxCreateDateTime.
We get a broken queue item saying: Invalid datetime format '**Invalid datetime format/Invalid datetime “.pxUpdateDateTime”**’. When an operator runs the report manually it works fine.
This does not occur on other environments. Does anybody have any suggestion as to where to look for the problem with the scheduled version?
Cheers,
Raijmond
***Edited by Moderator Marissa to update platform capability tags****
Accepted Solution
Achmea
NL
We have fixed this in our application by saving the pxUpdateDateTime as a number in a new property and we are using this property in the report to pull up the data by also implementing a Yesterday function that returns the date of yesterday as a number.
TCS
US
As this does not happen in other environment, feels like its the data which is different between environments.
1. pxUpdateDateTime can be null if it is new work object. can you try setting "Use Null if empty" in the filter condition from the gear icon.
Accepted Solution
Achmea
NL
We have fixed this in our application by saving the pxUpdateDateTime as a number in a new property and we are using this property in the report to pull up the data by also implementing a Yesterday function that returns the date of yesterday as a number.