[DUG]: Simple Question

[Jeremy Coulter]

HI All. I have been trying to work out HOW to do a query based on a date range in IB. I am used to the way that Access and SQL Server do their querys based on a date range, but this doesn't work under IB. I.e. SELECT * FROM myTable WHERE Date between 1/1/2000 and 1/12/200 or   SELECT * FROM myTable WHERE Date >=1/1/2000 and Date <=1/12/200   But neither of these worked under IB. I even tried to do a query on a specific date and it didnt even return anything. I am wondering if its because I need to specify the TIME as well i.e. date >= 1/1/2000 00:00:00 etc. But I am not sure how to do this under IB.   Thanks,   Jeremy Coulter (manager) Visual Software Solutions 145 Langdons Road Christchurch ph +64 3 3521595 fx +64 3 3521596 cell +21 2533214 http://www.vss.co.nz