Hi,

I have two text boxes which when submitted sends user input dates to a stored procedure which returns results between those dates.

My problem is that the stored procedure will only work if American format dates are input into the text boxes.

How can I make this work when putting English format dates in the text boxes?

I'm pretty sure its a SQL thing as the stored procedure wont work in Query Analyzer with english dates (unless I run SET DATEFORMAT dmy first) I cant do this when calling the stored procedure from the page though...

this is driving me mad,

any help much much appreciated,

Pete

OK,

I formatted it in c# first:

DateTime dtDate =
Convert.ToDateTime(Request.Form["txtBox"].ToString()).Date;

(Thanks Chris)