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
[quoted text, click to view] "news" wrote:
> Thanks, I changed it to datetime and it works fine.
>
> "Brian Welcker [MSFT]" <bwelcker@online.microsoft.com> wrote in message
> news:uMN%23TkVIFHA.2648@TK2MSFTNGP14.phx.gbl...
> > 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.
> >
> > "news" <news@ms.com> wrote in message
> > news:%23%23JAltSIFHA.3472@TK2MSFTNGP09.phx.gbl...
> >> 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.
> >>
> >
> >
>
>
