CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2ssrs-2012
whitz11
whitz11

Reputation: 229

Issue with concat expression

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

Upvotes: 0

Views: 37

Answers (1)

SuperSimmer 44
SuperSimmer 44

Reputation: 999

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

Upvotes: 1

Related Questions