Tuesday, March 20, 2012

Background expression

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