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

    Date SQL




      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?





      ("SELECT Sum (Occurrence)

      FROM CDCAttendanceIssues

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


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