iif statement

[pleasehelpalot]

I have a report with a Date Opened field. I want to check a box if the claim is within 60 days of the Opened Date. I'm trying to use an iif statement but it doesn't work. I'm not a programmer so i can use some help.
Here's what i have:

IIf ("DateOpened" <= Date() - 60, Check1 (1), Check1 (0))

What's wrong as it produces a compile error - Expected:=

Thanks

 

[SkipVought]

hi,

YourCkBox.Value = IIf  ([DateOpened] <=  Date() - 60, Check1(1), Check1(0))

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

Wouldn't it be:

YourCkBox.Value = IIf ([DateOpened] <= Date() - 60, 1, 0)

?

Have fun.

---- Andy

 

[pleasehelpalot]

Thanks Skip, but now the message says:
"You entered an expression that has no value

 

[pleasehelpalot]

Sorry, I just got it.