User!Language in textbox
I have a text box that has an expression set as follows:
=
"Dates between" & Parameters!tmFrom.Value &
" and " & Parameters!tmTo.Value
What I need is the Parameters to be formatted based on the User!Language. What syntax do I need to use in order to convert the dates to show as the regional settings with User!Language. I cannot set the property of the textbox
because it is a mix of text and dates.
Thanks in advance.
January 18th, 2011 9:37am
Hi,
Generally, if the textbox only contains the date parameter value, we can specify its
Language property to the expression =User!Language. So, the date can be displayed in the textbox with the format based on the client language.
However, if textbox is a mix of text and dates, it will be regarded as string and the format of the date part cannot be converted. Currently, as workaround, we need to use 4 separate
textbox instead one to display the text and 2 dates.
Thanks,
Tony ChainTony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 9:51pm