I've just moved to a new PC, and had BIDS installed on it. All machine dates are set to the international standard (dd/MM/yyyy).
I just opened an existing report to modify it that includes a date range in the parameters. When I tried to do a test preview of the report in BIDS, I got an invalid data error on the first date parameter. After a bit of fiddling around, I worked out that it would only let me input the dates in US format, yet after input the dates are converted to international format. When deployed to the report server, the report requires the dates to be input in international format.
I've spent half an hour checking my machine and BIDS to try and find the cause of this problem, and I'm stumped.
View Complete Post