Type mismatch error

[getziggy]

This query works fine on a live server using an MSSQL database:

<cfquery name="qIndex" datasource="#appDSN#" username="shampoo"
password="conditioner">
SELECT sch.ID, sch.Date, sch.Time, cat.Category,
sch.sName, sch.Email, sch.Status, sch.HomePhone,
sch.Dayphone, sch.ApplicationNo, sch.Note
FROM sfiec_scheduling sch, sfiec_scheduleCat cat
WHERE sch.Status = cat.CatID
<cfif isDefined("URL.ShowAll")>
<cfif isDefined("URL.past30")>
AND sch.Date < #CurrentDate# AND sch.Date > #CurrentDate#
- 31
</cfif>
<cfelse>
AND sch.Date >= #CurrentDate# - 1</cfif>
ORDER BY sch.Date ASC, sch.Time ASC </cfquery>

But when I try to use it locally on my testing server, I get the following
error:

Error Executing Database Query.
Type mismatch in expression.

The error occurred in
C:\CFusionMX7\wwwroot\SFInstitute\website\pub\sche duling\index.cfm: line 88
Called from
C:\CFusionMX7\wwwroot\SFInstitute\website\pub\sche duling\index.cfm: line 1
Called from
C:\CFusionMX7\wwwroot\SFInstitute\website\pub\sche duling\index.cfm: line 88
Called from
C:\CFusionMX7\wwwroot\SFInstitute\website\pub\sche duling\index.cfm: line 1

86 : </cfif>
87 : <cfelse>
88 : AND sch.Date >= #CurrentDate# - 1</cfif>
89 : ORDER BY sch.Date ASC, sch.Time ASC </cfquery>Text

Table was imported from the MSSQL table, but have also tried to recreate as a
new table. Date and Time fields are Date/Time in Access..datetime in MSSQL.

I also get a similar error when trying to insert a record in Access. I've also
tried running without the sort <cfif> statement, but get a similar error.

Thanks.

[MikerRoo]

Ditto Dan.

Anyway, there are a lot of problems with that posted code.

Here's a possible bandaid:
Change #CurrentDate# - 1 to #CreateODBCDateTime (CurrentDate -1)#