Ciao a tutti, ho il seguente problema:

SQL = " SELECT * FROM [QSO-TAB] WHERE [QSO_DATE] BETWEEN #" & QSData1 & "# AND #" & QSData2 & "# AND [TIME_ON] BETWEEN #" & QSTime1 & "# AND #" & QSTime2 & "# ORDER BY [QSO_DATE] asc, [TIME_ON] asc"
Response.Write SQL
Set RSlog = ConnLOG.Execute(SQL)

Mi restituisce questo errore:

SELECT * FROM [QSO-TAB] WHERE [QSO_DATE] BETWEEN #05/03/2008# AND #05/04/2008# AND [TIME_ON] BETWEEN #1959# AND #2001# ORDER BY [QSO_DATE] asc, [TIME_ON] asc

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '[QSO_DATE] BETWEEN #05/03/2008# AND #05/04/2008# AND [TIME_ON] BETWEEN #1959# AND #2001#'.

/contest-artivity/2008/aridx.asp, line 77