Sending Dates to Stored Procedure
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,