Report Definition configured to pull records for Last 30 days
I have noticed a wierd thing in Report Definition configuration on WorkObject table by using pxCreateDateTime Column in the where Clause to look for Last 30 days. (.pxCreateDateTime IsEqual "Last 30 Days")
But when i observe the ClipboardPage pyReportContentPage.pyPreparedValues it is
20160923T035959.999 GMT
( Todays Date & Time at EST timezone in USA is 20160922T192233.599 GMT [got it from a test activity by printing current DateTime], )
Query generated is
SELECT "PC0"."PYLABEL" AS "pyLabel" , "PC0"."PXCREATEDATETIME" AS "pxCreateDateTime" , "PC0"."PZINSKEY" AS "pzInsKey" , "PC0"."PXURGENCYWORK" AS "pxUrgencyWork" , "PC0"."PYID" AS "pyID" , "PC0"."PYSTATUSWORK" AS "pyStatusWork" FROM RULES.PC_SOM_TRAVEL_WORK_REIMBURS "PC0" WHERE ( "PC0"."PYSTATUSWORK" IN (? , ? , ? ) AND "PC0"."PXCREATEOPERATOR" = ? AND "PC0"."PXCREATEDATETIME" BETWEEN ? AND ? ) AND "PC0"."PXOBJCLASS" = ?
Date Values are 20160824T040000.000 GMT & 20160923T035959.999 GMT
I have noticed a wierd thing in Report Definition configuration on WorkObject table by using pxCreateDateTime Column in the where Clause to look for Last 30 days. (.pxCreateDateTime IsEqual "Last 30 Days")
But when i observe the ClipboardPage pyReportContentPage.pyPreparedValues it is
20160923T035959.999 GMT
( Todays Date & Time at EST timezone in USA is 20160922T192233.599 GMT [got it from a test activity by printing current DateTime], )
Query generated is
SELECT "PC0"."PYLABEL" AS "pyLabel" , "PC0"."PXCREATEDATETIME" AS "pxCreateDateTime" , "PC0"."PZINSKEY" AS "pzInsKey" , "PC0"."PXURGENCYWORK" AS "pxUrgencyWork" , "PC0"."PYID" AS "pyID" , "PC0"."PYSTATUSWORK" AS "pyStatusWork" FROM RULES.PC_SOM_TRAVEL_WORK_REIMBURS "PC0" WHERE ( "PC0"."PYSTATUSWORK" IN (? , ? , ? ) AND "PC0"."PXCREATEOPERATOR" = ? AND "PC0"."PXCREATEDATETIME" BETWEEN ? AND ? ) AND "PC0"."PXOBJCLASS" = ?
Date Values are 20160824T040000.000 GMT & 20160923T035959.999 GMT
Why is this distinction in dates 23 in one case and 22 is actual introduced by using the function for last 30 days
Let me know your thoughts
***Updated by Moderator: Lochan. Removed user added Ask the Expert tag. Apologies for confusion, shouldn't have been an end-user option***