all groups > sql server reporting services > june 2006 >
You're in the

sql server reporting services

group:

Problem with format of DateTime parameter



Problem with format of DateTime parameter RBot
6/4/2006 9:18:16 PM
sql server reporting services: I am in Australia.
Our machines have an Australian/English locale which as a date order of
Day/Month/Year.
I am using SQL RS 2005.

When I add a parameter of type DateTime and then preview the report a
strange thing happens.

* Use an Australian machine locale
* Create a dataset with no SQL. The dataset is just
SELECT @MyDateParm
* Create a simple layout that uses this dataset
* Preview the report. You should get the nice date selection dialog.
* Select 1st December 2005
* View the report - It switches magically to 12th January 2005
* View again - it switches back etc..

Now what is going on here?
(Professor Julius Sumner Miller)

(I know my likely solution is to move to the USA - or at least change
my locale :)
Re: Problem with format of DateTime parameter RBot
6/14/2006 5:03:17 AM
Has anyone ever encountered this problem?
I think it is a bug in RS2005.
Does anyone know how I could report this?

Thanks

[quoted text, click to view]
Re: Problem with format of DateTime parameter RBot
6/17/2006 7:29:24 AM
Well there are other people having problems with Date type parameters:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=286639

but where should I report this so it can be fixed?
AddThis Social Bookmark Button