1 Reply Latest reply on May 23, 2014 9:51 AM by philmodjunk

    ExecuteSQL confusion

    jbrogers1234

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