mark_wiley_miller@mac.com

Help with ExecuteSQL

Discussion created by mark_wiley_miller@mac.com on Jul 3, 2015
Latest reply on Jul 8, 2015 by mark_wiley_miller@mac.com

The Let Statement below works until I add the Where clause, not sure what is wrong with this syntax, Any help appreciated

 

Let (

 

 

callCount = ExecuteSQL(

 

 

"SELECT COUNT (Type) AS agg FROM Call_Log

  WHERE Au.Created.Date >= \'2014-01-01\'

  GROUP BY Type"

;

 

 

""; ¶) ;

 

 

callCount

 

 

)

Outcomes