AnsweredAssumed Answered

Date SQL

Question asked by gmotta on Aug 19, 2016
Latest reply on Aug 20, 2016 by gmotta



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