IIF function using dates if date is still null

[princessdmb]

Hello,

I'm trying to calculate the number of days between two dates using the iif statement

Fields:
[LDW] "Last Day Worked"
[ReturnedDate]

DESCRIPTION:
If ReturnedDate is null, then calculate the datediff "d" between LDW with Now(), if not, then calculate the datediff "d" between LDW with ReturnDate.

Not sure if the Iif function would be the appropriate to use or how to put it together.

I tried this but it didn't work at all. :banghead:
Days Absent: Iif(isnull([ReturnedDate],(DateDiff("d",[LDW],Now())),(DateDiff("d",[LDW],[ReturnedDate])))

Your help will be much appreciated!!!

Thanks

Denise ♥

 

[Minty]

Your IsNull should be after the ReturnedDate

IIf([ReturnedDate] is Null, TrueBit, FalseBit)

 

[princessdmb]

LOL.... (literally) such a small thing, thank you so much Minty!!

Have a great Holiday season!!

Denise ♥