Formatting Date Parameters in MS reporting services

[DiggerDog]

I've created a report which has a start end date passed to the SQL script - When I run the repot and I select something like 2 Jul 2006 it gets formatted to mm/dd/yy even so 07/02/2006 gets passed to the SQL which thinks I'm entering a date of 07 Feb 2006 instead of 02 Jul 2006 - Is ther anywhere I can adjust the parameter controls to ensure the correct date is passed to the code

 

[unclerico]

try something like:

SELECT field1, field2
  FROM table1
 WHERE field3 BETWEEN CONVERT(varchar,begin_date,101) AND CONVERT(varchar,end_date,101)

 

[DiggerDog]

I've tried that but the problem is calander control inverts the date before it passes it to the SQL code so converting it to a varchar doessn't make any difference - I've found another link which explains the problem more clearly.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=255248&SiteID=1

I've found that in design mode the problem exists but when I deploy the report it goes away - strange