Code:
" WHERE (((AS_Createsched.CSIN_dates) = # " & strdate & " #) " & _
You have spaces between the hash and the date - remove these and retry

Also try as a full string to make sure it works first then put variables in