date picker format

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!

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

|||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.|||

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!

|||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|||

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...

thanks for your help