0

Trying to string together a SSRS condition that set a parameter dynamically.

The user chooses 2 dates @StartDate and @EndDate. The expression i am trying to write will check to see if the 2 dates match and if they are the same datename as well. and if they do returns the value "Default" However I keep getting :

enter image description here

Here is the expression so far :

=IIF(FORMAT(Parameters!StartDate.Value, "dddd") = "Monday" & FORMAT(Parameters!StartDate.Value, "dddd") = "Monday" & Parameters!StartDate.Value = Parameters!EndDate.Value, "Default", "")
GPH
  • 1,817
  • 3
  • 29
  • 50

1 Answers1

2

& <> AND.

Use AND instead in the expression to combine Boolean expressions. 

=IIF(FORMAT(Parameters!StartDate.Value, "dddd") = "Monday" AND FORMAT(Parameters!StartDate.Value, "dddd") = "Monday" AND Parameters!StartDate.Value = Parameters!EndDate.Value, "Default", "")

& is used in SSRS to concatenate strings ("ABC" & "DEF").

Hannover Fist
  • 10,393
  • 1
  • 18
  • 39