Excel ODBC日期

Question

尝试使用ODBC驱动程序访问Excel文件作为数据库。并且需要确定天数的日期差异，并检查持续时间如下：

select A.IdNumber,A.UserNumber,A.StartDate,A.EndDate,B.StartDate,B.EndDate,A.TicketAmount,B.TicketAmount,A.Type,A.FromCity,A.ToCity,B.FromCity,B.ToCity 
from [Sheet1$] A, [Sheet1$] B    
where A.UserNumber = B.UserNumber 
and A.Type LIKE '%نتداب%' and B.Type LIKE '%نتداب%' 
and A.FromCity = B.FromCity and A.ToCity = B.ToCity 
and A.TicketAmount <> 0  and B.TicketAmount <> 0 
and ((DATEDIFF(day,B.StartDate,A.EndDate) = 1) or (DATEDIFF(day,B.StartDate,A.EndDate) = 0))

发生错误是： 运行查询：错误[07002] [Microsoft] [ODBC Excel驱动程序]参数太少。预期1。

没有最后一行：

and ((DATEDIFF(day,B.StartDate,A.EndDate) = 1) or (DATEDIFF(day,B.StartDate,A.EndDate) = 0))

谢谢。