View Single Post
  #1 (permalink)  
Old June 29th, 2004, 05:42 AM
pete_m pete_m is offline
Authorized User
 
Join Date: Apr 2004
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sending Dates to Stored Procedure

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