Simple SQL Question

From: Don (donald_callander_at_yahoo.co.uk)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 06:50:37 -0000

Im trying to construct a sql qry that Im going to execute via ado.

1. How do I set a SQL qry to search dd/mm/yyyy format? ie 25/12/2004

2. I would like to check that I dont have any schedule overlaps before
making a booking.
ie
AccNo FromDate ToDate
a010101 09/01/2004 12/01/2004

How would I go about checking that my new schedule dates dont conflict\fall
between these dates using a sql statement?

Im sure the answers are fairly simple, Im just not thinking.