URGENT: date parameter and regional location

Hi,

I have a report with startdate as a string report parameter formatted
MM/dd/yyyy. It works fine on the computer with regional setting to English
(United Stated) where its date formatted as MM/dd/yyyy. However, the report
parameter changes to dd/MM/yyyy on another computer with regional setting to
English (United Kingdom) where its date formatted as dd/MM/yyyy. The query
to SQL server fails since the date is invalid. How can I fix this? Thanks.

 

Is the parameter data type set to date / time? If so, it should work no
matter what the locale is. If you want it to be a specific one, set the
language of the report to the one where you want.

--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

 

Thanks, I changed it to datetime and it works fine.

 

Hi,

I'm facing the same problem with the dateformats.

I've set the datatype for the report parameter to Datetime. But still
getting the error.

When I try to pass the date in dd/mm/yyyy ( say 16-02-2005) it's woking fine.

But if I change it to 02-16-2005, it's not working. But as you said it
should work in any case.

Please let me know how to solve it.

srinivas