4 Replies Latest reply on Sep 5, 2016 8:06 PM by user19752

    SQL not searching Date

    gmotta

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