Comparing 2 Date Fields with Possible Nulls

[sardine53]

Hello,

Using Access 2007

I need to have a query than returns the greater of 2 dates. This works if only if there are no nulls/blanks:

MaxOfAAndB: IIF([DATE_A]>[DATE_B],[DATE_A],[DATE_B])

Can I use a NZ function with this query? If so, how? If not, what should I use?

(I know I can use function but I would rather use a query.)

Thanks in advance!

 

[PHV]

Like this ?
MaxOfAAndB: IIF(Nz(DATE_A,0)>Nz(DATE_B,0),DATE_A,DATE_B)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sardine53]

Works great. Thanks so much!