请教一个日期查询的问题(50分)

飞

飞天雪

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-19

• #1

我想实现这样的功能：过滤出一个区间段的时间
下面是我的代码，请帮我分析一下，谢谢！！
出错信息：zong:field' datetimepicker1.date' not found
begin
with zhuanli.zong do
begin
filtered:=false;
filtered:=true;
filter:='(a_time>=DateTimePicker1.Date) and (a_time<=DateTimePicker2.Date)';
filtered:=true;
end;
end;

 

R

realLearning

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-19

• #2

引号的位置搞错了
‘a_time>='+DateTimeToStr(DateTimePicker1.Date)+
'and a_time<='+DateTimeToStr(DateTimePicker2.Date)

 

G

genue

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-19

• #3

将
filter:='(a_time>=DateTimePicker1.Date) and (a_time<=DateTimePicker2.Date)';
改为
filter:='a_time>='+datetimetostr(DateTimePicker1.Date)+' and '+'a_time<='+datetimetostr(DateTimePicker2.Date);

 

Y

yanghaijun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-19

• #4

filter:='(a_time>=DateTimePicker1.Date) and (a_time<=DateTimePicker2.Date)';
filter:='(a_time>='+QuotedStr(DateToStr(DateTimePicker1.Date))+') and (a_time<='+
QuotedStr(DateToStr(DateTimePicker2.Date))+')';

 

飞

飞天雪

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-19

• #5

接受答案：）