Posted: 2 May 2019 10:29 EDT Last activity: 17 May 2019 6:52 EDT
Invalid datetime format: pxUpdateDateTime
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?
***Edited by Moderator Marissa to update platform capability tags****
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.