date comparison 1

[mikeba1]

I need to change a text field on a report depending whether the current date is > 31/12/2007

I am trying to put an iif function in the control source but seem unable to get it to work.
I'm not sure what the syntax should be when comparing the current date.

i.e iif(date()>'31/12/2007', "action a',action b')

any help greatly appreciated

 

[missinglinq]

iif(date()>#31/12/2007#, action a,action b)

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!