Make sure that the date string in the SQL is enclosed in single-quotes: I.E.

datRequired = '11/18/2011'. I'm not sure what the "convert" function above returns but it probably does not include the enclosed quotation marks.

-Max