AnsweredAssumed Answered

Date SQL

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

I need to creat an SQL that sum all values for dates in the last year...but when it comes to the WHERE clause...it is not working.

 

This is what I'm trying

 

WHERE Date > get(currentdate) - 365.

 

What am I doing wrong???

 

I have Date column on a table with all dates listed as below...

 

8/6/2015

8/17/2015

9/16/2015

10/20/2015

1/23/2016

 

etc....

 

I NEED HELP!

Outcomes