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
, fields!Freeze.Value
Here is how it would look in VB.NET code
If fields!Freeze.Value = true
Fields!effectdate.Value
else
IIF(Month(Fields!effectivedate.Value) <> Month(Now()), Now(), Fields!effectdate.Value)
end if
How would I write this in SSRS code?
Please ask for further clarification if i have failed to explain something properly.