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

sql server reporting services

group:

DateTime Parameter need yyyy-mm-dd format


DateTime Parameter need yyyy-mm-dd format MJT
6/23/2006 10:54:02 AM
sql server reporting services:
I have a parm defined as DateTime in RS2005 (so you see the calendar control
for the parm) .. when selected ... the format is mm/dd/yyyy and I need it to
display yyyy-mm-dd as it was when we had date defined as string rather than
DateTime. I went into regional settings on my pc and changed the date
setting in my regional options to display date as yyyy-MM-dd and it still
RE: DateTime Parameter need yyyy-mm-dd format Maran
6/26/2006 12:12:02 AM
Hi.

You have a language setting in the reports properties.

The default setting for language is "English (United States)". You can
change that either to what the user have choosen in IE by chosing "Default"
or what you want it to be. If you need yyyy-MM-dd you just change to your
country's setting.

You can override this setting for certain textboxes if you like. Textboxes
have their own language setting.

Kind regards
Maran

*********************

[quoted text, click to view]
RE: DateTime Parameter need yyyy-mm-dd format MJT
6/26/2006 6:22:02 AM
Thank you Maran,
I had changed my regional settings in control panel prior to posting my
message, but I didnt realize that they wouldnt take effect until I closed out
of VS and re-entered. Which brings another question to mind. If we want the
date displayed as yyyy-MM-dd format can that be accomplished solely by
setting to "English(United States)"? Because when I noticed the problem
initially, I had my windows settings for date format as MM-dd-yyyy and my
language was English(United States) and that seemed to be why I saw the date
format as MM-dd-yyyy when I changed my parameter to DateTime format. I am
wondering if the users have their date format in windows set other than
MM-dd-yyyy if just making the language English(United States) will matter at
all now. Since that was the way my settings were originally. Is there a way
to enforce a date time format? I realize that each textbox has a format
parameter, but this textbox that referenced the date parameter had other code
in it which was being translated into multiple languages in a code block - so
I cant use the format property on the textbox itself - I would have to put it
in the code block somehow. Thanks again for your reply.

[quoted text, click to view]
RE: DateTime Parameter need yyyy-mm-dd format MJT
6/28/2006 9:44:01 AM
I handled this by adding the format to my custom code. Thanks.

[quoted text, click to view]
AddThis Social Bookmark Button