I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database.
dtsdate.DataSet := qrydate ;
qrydate.Active := false ;
qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ;
qrydate.Active := true;
in she shown exaple where the date of 1994/02/05 is the center of the avaiable dates I get no records but if i change the smaller than sign to a bigger than sign, all records are selected Can anyone please help me. Thank you.