Issue with concat expression

Question

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

Answer 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")