0
=IIF(IsNothing(Fields!actual_end.Value)) or (Fields!actual_end.Value >= DATEADD("d",-7,TODAY()),false, true)

I want the row to be visible if the value is blank or if the value is greater than or equal to one week ago. Having a little trouble with the expression.

S3S
  • 24,809
  • 5
  • 26
  • 45
Femmer
  • 133
  • 12

1 Answers1

0

You had an extra bracket in the IIF expression.

=IIF(IsNothing(Fields!actual_end.Value) or (Fields!actual_end.Value >= DATEADD("d",-7,TODAY()),false, true)
S3S
  • 24,809
  • 5
  • 26
  • 45
controller
  • 185
  • 1
  • 2
  • 11