AND Expression

[mardimus]

I am trying to create an expression that lists a value in a new column based on the logic that a date has passed today. Any help on how to recreate this as the Today or AND expression is not working.

Was Project Delinquent?:=IIF(AND(IsNull(Date1),[Date2]<TODAY()),1,0)

Thanks for any help.

Marty

 

[Joe4]

The equivalent in Access would look something like:

IIf(IsNull([Act RFU]) And ([Comp RFU] < Date()),1,0)

<date()),1,0)[ code]<="" html=""></date()),1,0)[>

 

[mardimus]

The equivalent in Access would look something like:

IIf(IsNull([Act RFU]) And ([Comp RFU] < Date()),1,0)

<date()),1,0)[ code]<="" html=""></date()),1,0)[>

This worked. Thanks so much.