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***
Pegasystems Inc.
US
The end date in the date range is midnight for you in the Eastern US which is currenty offset from GMT by -04:00 hours. In other words it is 4:00am in Greenwich when it is midnight in New York.
The start date is 30 days prior to that time. There are 31 days in August so shows Aug 24 (20160824) not Aug 23 which would be 20160823.