What if one just manually add the times to your SQL query?

I have been doing something like this:

" WHERE DATEFIELD BETWEEN " & @DATE1 & " 00:00:00" & " AND...