Coding for a date parameter.

I am trying to code the building of an sql string to download some data from SQL server into excel.

Please Login or Register  to view this content.

I get an error message on the WHERE clause of the SQL string marked with XX XX. I hope I have my ' and " in the right places but I am not sure. Can any one help me with the correct syntax?

I had some very useful help on coding a single date a few weeks back and I am disappointed that I have been unable to extend this to a two date situation.
John

When you debug.print strsql. What's the exact string that's shown?

I think you are missing single space before "AND" but not sure.

The value of sqlstr when optionbutton 1 was clicked was (from Debug.Print)
SELECT hafgfk__.fak__ref, hafgfk__.dok__dat FROM sqlb00.dbo.hafgfk__ hafgfk__WHERE (hafgfk__.dok__dat Between' 03/21/2017 'AND ' 03/21/2017 ')

I think I have managed to get the coding around the parameter dates right. However there is still an error message telling me that the hafgfk__ in the WHERE clause is not a recognised "table hints option"
If I REM out the WHERE clause, the SELECT and FROM clauses work fine. So hafgfk__.dok__dat was accepted in that case. I am confused and a little out of my depth.
John

You are missing space before "WHERE" and and you got extra spaces inside single quotes...

Try below, with added space to xlnitwit's modification. Change date format as needed (I usually use yyyy-mm-dd myself).

Please Login or Register  to view this content.