Iff problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
Click to expand...

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?
 
Back
Top