AnsweredAssumed Answered

ExecuteSQL confusion

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

Title

ExecuteSQL confusion

Post

     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') ";
      
                         "";
      
                        ""
                       )
      

Outcomes