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...
I NEED HELP!