Hi All,
I tried using the following Expression in a field's background property:
=iif( Fields!ProjectedDate.Value between (getdate()+1) and (getdate()+7), Orange ,White )
And then I got this message, anyone got any ideas?
The background color expression for the textbox 'textbox49' contains an error: [BC30455] Argument not specified for parameter 'FalsePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
=iif( Fields!ProjectedDate.Value < (getdate()+1) AND Fields!ProjectedDate.Value > (getdate()+7), Orange ,White )
I dont think you can use between in expression.
sql
No comments:
Post a Comment