AnsweredAssumed Answered

ExecuteSQL confusion

Question asked by jbrogers1234 on May 23, 2014
Latest reply on May 23, 2014 by philmodjunk


ExecuteSQL confusion


     Attached is the SQL query that I wrote to count the number on Mondays between two dates from a holiday table. It is not running I get  '?' :

     ExecuteSQL ( "
                         SELECT COUNT (* ) 
                         FROM HolidayList H,
                         WHERE H.~date between StartDate and EndDate  and H.WeekDay IN ( 'Monday') ";