求助:不执行查询的问题

[bluesky1980]

我在按钮的CLICK事件中加入如下代码.
dim str as string
str = "{table1.time}='" & DTPicker1.Value & "'"
and {table1.time}<'" & DTPicker2.Value & "'"
CrystalReport1.ReportFileName = "d:\table1.rpt"
CrystalReport1.SelectionFormula = str
CrystalReport1.Action = 1

结果报表中什么都不显示(也就是未执行查询)
数据库中time字段为DATATIME类型

不知道是什么原因,望解答
谢谢!

[bluesky1980]

问题已解决
我用的是这个
"'" & Year(DTPicker1.Value) & " /" & Month(DTPicker1.Value) & " / " & Day(DTPicker1.Value) & "'"

谢谢大家

[tonnyhe]

str = "{table1.time}='" & DTPicker1.Value & "'"
and {table1.time}<'" & DTPicker2.Value & "'"

此句有错，应该是
str = "{table1.time}>'" & DTPicker1.Value & "'
and {table1.time}<'" & DTPicker2.Value & "'"

[bluesky1980]

tonnyhe(快乐编程) : 我的贴子笔误：）应该是”大于号“
但程序还是不执行报表数据项显示为空

[zjcxc]

试试：

dim str as string
str = "datediff(day,{table1.time},'" & DTPicker1.Value & "')=0"
and datediff(day,{table1.time},'" & DTPicker2.Value & "')>0"
CrystalReport1.ReportFileName = "d:\table1.rpt"
CrystalReport1.SelectionFormula = str
CrystalReport1.Action = 1

[tiger201]

将DTPicker1.Value,DTPicker2.Value转换成table1.time一致的数据格式。
即使同为DATATIME类型也会因为显示格式不同而无法查询到数据。

[bluesky1980]

zjcxc(邹建) :
运行程序后报错 error in formula <record_selection>
str = "datediff(day,{table1.time},'2003-12-1')<0
and datediff(day,{table1.time},'2003-12-4'>0"
the remaining text does not appear to be part of the formula

tiger201(你是风儿我是沙，编程不如种地瓜。) :即使同为DATATIME类型也会因为显示格式不同而无法查询到数据。如果出现你说的这种情况该如何解决