在SQL中的日期类型如何和DTPicker控件进行比较呢？我的这种方法为何不可以呢？？？

[fxs]

Tsql = "SELECT cdepartment, ccalnum,cname, cpcalnum, mquitmoney,dquitdate,

blosscal,badcal,dsenddate From QuitCalWhere (dquitdate >=DTPicker2.Value And

dquitdate <= DTPicker1.Value )"

用Debug去调试时出现的是下例的：
SELECT cdepartment, ccalnum, cname, cpcalnum, mquitmoney, dquitdate, blosscal,

badcal, dsenddate FROM QuitCal

WHERE (dquitdate >= 2002 - 12 - 14 AND dquitdate <= 2003 - 11 - 14)

其中dquitdate是日期型，为何会查不到记录呢》

[fxs]

这是用不查询在两年日期时间断所发生的记录。哪位大吓来帮一下哟

[fxs]

用来查询两个日期断的所有记录

[kimurakenshin]

Tsql = "SELECT cdepartment, ccalnum,cname, cpcalnum, mquitmoney,dquitdate,

blosscal,badcal,dsenddate From QuitCalWhere (dquitdate >='" & DTPicker2.Value & "' And

dquitdate <= '" & DTPicker1.Value & "')"

SELECT cdepartment, ccalnum, cname, cpcalnum, mquitmoney, dquitdate, blosscal,

badcal, dsenddate FROM QuitCal

WHERE (dquitdate >=' 2002 - 12 - 14' AND dquitdate <= '2003 - 11 - 14')

注:日期两边必须要加单引号.