Hi

I am trying to query a date range on a single datedate field in sql 2000 db - the query below will not work if I do a search on say 21/07/2003 to the 21/07/2003, although there are records on for that day.

Can anyone help ??

SELECT *
FROM dbo.WA
WHERE ((([wa].date)>='start')) AND ((([wa].date)<='finish'));

Thanks

1.Is wa.date a datetime/smalldatetime field?
2.How dates are represented in your table: dd/mm/yyyy or mm/dd/yyyy? Maybe you should consider a cast (see cast and convert in SQL Books Online) in the WHERE clause.