Hi, i'm using the date picker to try and allow the user to select two dates and the let them run a table query to find all the records between the two dates.

I got the date picker outputing the strings date1 & date2 and these are getting displayed in text boxes.

1.) How do i get rid of the time that is thrown in with the date picker? only need the date.

2.) how can i create a query that allows me to have the String 'date1' included in it without defining any values.

e.g.
SELECT BookingID, [Date Of Booking], [Date of Arrival], [Date of Departure], CustomerID
FROM [Booking Table]
WHERE Date_Of_Booking >= date1 AND Date_Of_Booking <= date2

Thanks for the any help,

Ewan