minority80


hi all,

i've just updated my sql server 2005 with sp1 and sp2.

i want my report date format to change according to regional setting, therefore i've set the report property for language as User.Language.

how do i set the report parameter of type datetime to follow the format of regional setting

my date parameter has default value which i query from a table.

for e.g. if my regional setting is UK and the default date is 9/7/2006, the date picker will display date at 7 september 2006 instead.

please help.... thanks!




Re: date picker format

minority80


i've also enter the format i wanted in IE option..






Re: date picker format

adolf garlic

If you have a parameter of datetime, and the report language setting is user!langauge, and the datetime in IE is not coming out as expected, then you do not have you local regional settings set up correctly.








Re: date picker format

minority80

thanks for your reply adolf...

my pc regional setting:

Regional Options tab:

Standard and formats:

English (United Kingdom)

Short date: 14/06/2007

Long date: 14 June 2007

Location: United Kingdom

Advanced tab:

Language for non-Unicode programs:

English (United Kingdom)

anywhere else to check thanks!





Re: date picker format

adolf garlic

In IE but I think you said you already checked this:

IE: tools - options - general - [languages...] -

There may be something else to check, if the above doesn't work let me know and I'll try and find out





Re: date picker format

minority80

in IE, Language: English (United Kingdom) [en-gb]

still not working... is it because of the default value of the parameter but it's displaying the correct format for the date... Sad

thanks for your help