Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Apr 21, 2005 10:32 PM by ndinakar
Apr 21, 2005 06:42 AM|LINK
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?
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.