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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!