I think I might have got it

SELECT userID, SUM(Correct) AS CORRECT, SUM(Wrong) as Wrong, SUM(AssitanceNeeded) AS AssitanceNeeded

FROM Charts

where TimeDateStamp between

dateadd(month, -11, DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))

and

dateadd(ss,-1, DATEADD(mm, DATEDIFF(mm,0,getdate()) + 1, 0))

GROUP...

antonio.collins (1/26/2008)

---

sorry the comparison should be TimeStamp >= date expression

run these statements:

select dateadd(month, -12,

dateadd(day,1 - day(getdate()), ...

antonio.collins (1/26/2008)

---

try this instead:

where TimeDateStamp <=

dateadd(month, -12,

dateadd(day,1 - day(getdate()),

...