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 '?' :
What kind of field is WeekDay? Is it a calculation field? If so, is text specified as the result type?
And you may need to refer to the H.~date field as: H.\"~date\" if FileMaker SQL doesn't like field names that start with ~.