I have a date field [orderDate] on a form, and a calculated text box with control source:=IIf([orderdate]>"30/04/2009",2,1)... the idea being that the box will display 1 for order dates up to 30th Apr 2009, and thereafter a 2.
Why is it 1 whatever date I enter?
Thanks
Mike.