Iff problem

[rms10]

I am using =IIf([DateRequired] Is Not Null,DateDiff("d",[DateRequired],[DateReceived]),DateDiff("d",[DateRequired],Date())) in a non bound text box to inform me of the days an item is overdue. For some reason the false condition does not work. Any help would be appreciated.

 

[rms10]

That should be IIF in the subject not IFF

 

[Joan Wild]

I am using =IIf([DateRequired] Is Not
Null,DateDiff("d",[DateRequired],[DateReceived]),DateDiff("d",[DateRequired]
,Date()))
in a non bound text box to inform me of the days an item is overdue.
For some reason the false condition does not work. Any help would be
appreciated.

The false portion would mean that DateRequired was null. What would you
expect the DateDiff to return for 'number of days between null and today's
date?

 

[rms10]

Hehe thanks, seems I had the wrong field check