Those queries are for SQL SERVER ONLY
This thread was about JET OLEDB queries. That is, queries into an ACCESS
Neither the Access nor JET drivers have CONVERT() or GETDATE() functions.
Those queries aren't even very good if you are using SQL Server.
JUST FOR EXAMPLE:
... WHERE column3 BETWEEN GetDate()-1 AND GetDate()
GetDate() returns the current date *AND TIME*.
So let's say you make that query at 17:00:00 (5 PM) today.
Essentilly, you are asking for
... WHERE column3 BETWEEN (5 PM yesterday ) AND ( 5 PM today )
So, for example, you won't find records from 11 AM yesterday.
WORSE: If column3 is a DATE-ONLY column, then you wont' find ANY records from yesterday.
I think you might want to go revisit your SQL Server documentation to find better ways than what you are doing there.