AnsweredAssumed Answered

Issue with my eSQL, need help.

Question asked by xxx202xxx on Jun 13, 2017
Latest reply on Jun 13, 2017 by 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 ) )

Outcomes