2 Replies Latest reply on Aug 20, 2016 12:26 AM by gmotta

    Date SQL

    gmotta

      Hello,

       

      I  have an SQL and it work fine....But I can't get the date part to work....can anyone tell me how I could Sum all data for the past 30 days or 12 months....it would be Date > Current Date - 365. Anyone can help?

       

       

      ExecuteSQL

       

      ("SELECT Sum (Occurrence)

      FROM CDCAttendanceIssues

      WHERE UserID=? AND \"Date\">'07/01/2016'";

       

      "" ; "" ;CDCAttendanceIssues::UserID;CDCAttendanceIssues::Date)