Hello

SQL Server 2005

I have tried and cannot return any rows either though there are records that should be returned, using the sql below.

Code:
SELECT * FROM Calls WHERE clientName IN ('Bankside Engineering Limited') 
AND scheduleDate BETWEEN 20/5/2007 AND 30/5/2007
In the database scheduleDate is a dateTime datatype.

In the database I have copied and pasted.
23/05/2007 00:00:00

I tried the following
Code:
SELECT * FROM Calls WHERE clientName IN ('Bankside Engineering Limited') 
AND scheduleDate BETWEEN '20/5/2007' AND '30/5/2007'
And got an error message:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Many thanks for any help with this,

Steve