gmotta

SQL not searching Date

Discussion created by gmotta on Sep 5, 2016
Latest reply on Sep 5, 2016 by user19752

Hello,

 

I came up with an SQL to calculate the  filtered values in a portal and it is working fine ...its a couple of if statements but it is working. Only problem now is I want to add one more  search parameter which is to count all values greater than my global search date on the filtered portal....But I seem to be messing it up some how.

 

Can anyone help? Thanks in adavance....SQL follows below...

 

 

If(CDCAssociates::Global=1;

 

ExecuteSQL ("SELECT Count (Shift) FROM CDCPPMLog WHERE Shift=?

 

AND CDCPPMLogDate CDCAssociates::SearchStartDate"; "" ; "" ;CDCAssociates::Global); .....and so on....

Outcomes