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'.
Tjopsta
Member
5 Points
1 Post
Background expression
Apr 21, 2005 06:42 AM|LINK
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'.
ndinakar
All-Star
49092 Points
6868 Posts
Moderator
MVP
Re: Background expression
Apr 21, 2005 10:32 PM|LINK
=iif( Fields!ProjectedDate.Value < (getdate()+1) AND Fields!ProjectedDate.Value > (getdate()+7), Orange ,White )
I dont think you can use between in expression.
Dinakar Nethi
Life is short. Enjoy it.
***********************