I have a report with a dateTime type report parameter, which is used in a where quairy in sqldatasource . It works when I run it with with this
Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
in the report initializer.
How ever when running the report in my default culture (is-IS) the report fails with the message
The conversion of nvarchar data type to datatime data type resulted in an out of range value.
This happens when the day of month is greater than 12 , so it thinks that the day is the month.
Is this a bug ?.