7 Replies Latest reply on Aug 20, 2016 2:00 PM by gmotta

    Date SQL

    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!