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

    Simple Execute SQL Statement not working

    madmike6537

      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?