0

Can someone explain what is happening here please, looking at the expression below, when I run the report the 'to' comes out as 'Ao' 

="Date Range Selected: " & Format(Parameters!DateFrom.value, "yyyy/MM/dd" &" to " & Format(Parameters!DateTo.value, "yyyy/MM/dd"))

Date Range Selected: 2017/01/01 Ao 2017/04/19

Thanks

whitz11
  • 229
  • 2
  • 23

1 Answers1

1

You need to closing brackets around the first format function and remove the second closing brackets at the end: ie....

="Date Range Selected: " & Format(Parameters!DateFrom.value, "yyyy/MM/dd") &" to " & Format(Parameters!DateTo.value, "yyyy/MM/dd")
Andrii Litvinov
  • 12,402
  • 3
  • 52
  • 59
SuperSimmer 44
  • 964
  • 2
  • 7
  • 12
  • 1
    It's better to not put it all in one expression. Use placeholders to hold the dynamic text - then you can format the placeholder and not use the format function, as well as see what the text says without having to edit the expression. More information about placeholders: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/formatting-text-and-placeholders-report-builder-and-ssrs – BishNaboB Apr 19 '17 at 10:24