I'm a matric pupil writing a database delphi project for computer studies. It is a bussiness that hires out products. I'm trying to Display all bookings in a table bookings where a product is out/not available for a certain day. In the SQL property of a ADOQuery I wrote the following:
SELECT * FROM Bookings WHERE Date BETWEEN Date_Out and Date_In
The program displays no records even if I have check manually that there are such records.The DBGrid displays all the records when I scrap the where part and it also works for other Queries, so the problem must be in the date part. I've tried to add DateToStr and StrTodate but it doesn't help. Please help!!