with adoquery1 do begin close; sql.clear; sql.add('select sum(工资) from tablename where 日期 between :begintime and :endtime'); parameters.parambyname('begintime').value := datetimepicker1.datetime; parameters.parambyname('endtime').value := datetimepicker2.datetime; open; end;
begin
close;
sql.clear;
sql.add('select sum(工资) from tablename where 日期 between :begintime and :endtime');
parameters.parambyname('begintime').value := datetimepicker1.datetime;
parameters.parambyname('endtime').value := datetimepicker2.datetime;
open;
end;
s为string;s:=inttostr(Trunc(datetimepicker1.Date)-Trunc(datetimepicker2.Date)));
谢谢你,不过我说的不是样,,DateTimePicker1,或DateTimePicker2 是DELPHI的控件,我想取它们下拉时的日期 ,,,在取二者的日期差
谢谢了!!!!!!!!!!!!!!!
不行呀,,,DateTimePicker2。DATE可以可是,,,str:=DateTimePicker2。DATE就不可以了,
s为string;s:=inttostr(Trunc(datetimepicker1.Date)-Trunc(datetimepicker2.Date)));