logic flow date format manipulation SSRS
Posted on 2013-01-04
I have the following code
=IIF(Month(Fields!effectivedate.Value) <> Month(Now()), Now(), Fields!effectdate.Value)
In this code I check to see if Fields!effectivedate.Value is the current month.
If it is the current month then it displays Fields!effectivedate.Value.
If it is not the current month then it displays the current date.
I would like assistance on the following.
1. In addition to doing this check I would like to check for another value
Here is how it would look in VB.NET code
If fields!Freeze.Value = true
IIF(Month(Fields!effectivedate.Value) <> Month(Now()), Now(), Fields!effectdate.Value)
How would I write this in SSRS code?
Please ask for further clarification if i have failed to explain something properly.