Can you reformat date parameter values ​​in Reporting Services?

Question

Is it possible to convert the format of the date value passed to the request? I am trying to create a report that interacts with the SAP back-end, but the request uses a different format for date objects. I need to select the selected date and reformat it to "yyyy.mm.dd" (including quotation marks). Is it possible? I can do it as a text box, but it's a little ugly. Any advice would be appreciated.

Answer 1

When a parameter is passed to your sql in the dataset of your report, you can change the expression. For example, this is the default code.

=Parameters!StartDate.Value

You can change it, basically the expression is like vb code

="""" + Year(Parameters!StartDate.Value).ToString() + "." + Month(Parameters!StartDate.Value).ToString() + "." + Day(Parameters!StartDate.Value).ToString() + """"