3 Replies Latest reply on Apr 27, 2015 6:34 PM by user19752

    Simple Execute SQL Statement not working


      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?