Date issue, using BETWEEN

tdaustin · June 8th, 2004, 05:52 PM

Hi Everyone,

I am having a problem with a BETWEEN statement using dates.

Im testing my app on MS Access and it works fine, but when im reading off SQL 2000 it fails the error received is

Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '#'.

Does SQL 2000 require different syntax?

You advice would be much appreciated.

Tim :)

** SQL Statement ***

Code:

strSQL = "SELECT Opp.OppID, Opp.OppRef, Opp.OppName, Opp.OppDescShort, Opp.OppPublished, Opp.OppClosing " & _
                     "FROM GamesLink_Opportunities " & _
                     "AS Opp WHERE (Opp.OppPublished BETWEEN #"&DateFrom&"# AND #"&DateTo&"#) ORDER BY Opp.OppName"

TDA

Snib · June 8th, 2004, 06:07 PM

I think you should replace the '#' with single quotes (').

Let me know if it works.

Snib

<><

tdaustin · June 8th, 2004, 08:01 PM

Yes that worked.

I swear i tried that and it didn't work but i did!

I feel so stupid!

Thanks

Tim

TDA