Data base - Firebird 2.5
ZeosDB 7
When I set filter, from date to date, I can not see any record.
What is wrong with my code
procedure TFormVozila.BitBtnIzvPojStampaClick(Sender: TObject);
var
cDat1, cDat2, cFilter: string;
begin
cDat1:=DateToStr(ZVDateTimePickerIzvOdDatuma.Date);
cDat2:=DateToStr(ZVDateTimePickerIzvDoDatuma.Date);
RLLabelIzvPojOdDatuma.Caption:=cDat1;
RLLabelIzvPojDoDatuma.Caption:=cDat2;
cFilter:='(DATUMPOLASKA>='+cDat1+') and (DATUMPOLASKA<='+cDat2+') and (REGBR='+QuotedStr(EditIzvRegBr.Caption)+')';
ZQueryNalog.Filter:=cFilter;
ZQueryNalog.Filtered:=True;
ZQueryNalog.First;
RLReportPojedina.Preview(NIL);
RLReportPojedina.ClosePreview;
RLReportPojedina.Visible:=False;
end;
where DATUMPOLASKA is field Date type at table NALOG?