Error 80040e07

[JJF]

Microsoft JET Database Engine error '80040e07'

Syntax error in date in query expression 'eventdate between # 2/1/2013# AND #2/31/2013# AND active = 1'.

/test/calendar.asp, line 38

El código en esa línea es el siguiente:

Código:

34    MainSQL = "Select ID,eventdate,eventtime,eventname,eventdesc from 
tblcalendar where eventdate between # " & godatefirst & "# AND #" & godatelast & "# AND active = 1 order by eventdate,eventtime;"
35    set Conn = server.createobject("adodb.connection")
36    Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath
37    Set RS = Server.CreateObject("ADODB.recordset")
38    RS.Open mainSQL, Conn, 1, 3

La coneción llega a través de un include.
Alguien me podrá ayudar, por favor? Muchas gracias!

[u_goldman]

Depende de tu base de datos:

Si es access, ademas de las almohadillas tienes que pasar un string (si no me equivoco, tiene
muchisimo que no trabajo con access)
Si es cualquier cosa que no sea access, tiene que ser un string

Access:

Código ASP:

MainSQL = "Select ID,eventdate,eventtime,eventname,eventdesc from 
tblcalendar where eventdate between '# " & godatefirst & "#' AND '#" & godatelast & "#' AND active = 1 order by eventdate,eventtime;"
 

No Access:

Código ASP:

MainSQL = "Select ID,eventdate,eventtime,eventname,eventdesc from 
tblcalendar where eventdate between '" & godatefirst & "' AND '" & godatelast & "' AND active = 1 order by eventdate,eventtime;"