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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics