12 Replies Latest reply on Jun 13, 2017 8:38 AM by xxx202xxx

    Issue with my eSQL, need help.

    xxx202xxx

      I am having an issue trying to get data to return.  No (?) just no data.  Basically I am trying to retrieve tickets by it Status for a Specific User for the current month.  This info will be used for label names for a pie chart.  When the date portion is taken out, data is returned.  What am I doing wrong?

       

      ExecuteSQL("

       

      SELECT Status
      FROM Service_Management
      WHERE Contact=? AND MONTH(Date_Created)=?

       

      "; "" ; "" ;Upper (Get ( AccountName )); Month ( Get ( CurrentDate ) )