Question

1
Replies
2733
Views
VamsiK63 Member since 2013 7 posts
State of Maine
Posted: 4 years ago
Last activity: 4 years ago
Closed

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

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***

Reporting
Moderation Team has archived post
Share this page LinkedIn