SQL not searching Date

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



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





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


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