all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

Set format to a date parameter



Set format to a date parameter GeVa
5/7/2007 5:55:00 AM
sql server reporting services: I have created a Report which a date parameter. I want to have the dutch
format (dd/MM/yyyy). So I set the browser to [nl]. The first time I start the
browser the datepicker is in english and in the format is in MM/dd/yyyy. The
next time I see the dutch names of the days of the week en the format is also
(dd/MM/yyyy).
Who as any idea why the first time I start the browser I have the wrong
language.

RE: Set format to a date parameter Elle
5/7/2007 8:45:23 AM
Only having to work in English, I've never used the browser to change language settings, but maybe you could put the code in your parameters so that you never have to worry about what the browser (and which browser it is) may be doing?

So maybe in the query to pull the parm values you could format it,
format(Parameters!YourDate.Value, "M/dd/yyyy") or whatever format you want as the label.

Or if you only have a few values just type them in the way you want them to show for the label--force it through the code--not the browser.

From http://www.developmentnow.com/g/115_2007_5_0_0_967272/Set-format-to-a-date-parameter.htm

Posted via DevelopmentNow.com Groups
RE: Set format to a date parameter GeVa
5/11/2007 12:45:42 AM
It could be a solution, but someone else has an other solution:
In the url-> ....&ParameterLanguage=nl-NL

Thank you for responding.

From http://www.developmentnow.com/g/115_2007_5_0_0_967272/Set-format-to-a-date-parameter.htm

Posted via DevelopmentNow.com Groups
AddThis Social Bookmark Button