AnsweredAssumed Answered

Simple Execute SQL Statement not working

Question asked by madmike6537 on Apr 26, 2015
Latest reply on Apr 27, 2015 by user19752

ExecuteSQL (

 

 

"SELECT Sum(Line_Item_Total) FROM CUSTOMER GROUP BY MONTH(Actual_Setup_Date), YEAR(Actual_Setup_Date)"; ""; "")

 

 

If I take out the "GROUP BY" it works fine. Seems to not like my date field. Any ideas on why it wouldnt work with my date field?

Outcomes