AnsweredAssumed Answered

Date SQL

Question asked by gmotta on Aug 19, 2016
Latest reply on Aug 20, 2016 by 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)

Outcomes