View Single Post
  #8  
Old May 15th, 2010, 07:52 PM posted to microsoft.public.access.forms
Bob Quintal
external usenet poster
 
Posts: 939
Default out of date items

Bob H wrote in
:

On 15/05/2010 17:21, Bob Quintal wrote:
Bob wrote in
:

On 15/05/2010 12:35, PieterLinden via AccessMonster.com wrote:
IIF(DateDiff("d", NextTestDate, Date())=7,"Out of Date
Soon","OKAY")

This works ok, but for items that are well out of date, or past
the NextTestDate, they were shown as OKAY, So I removed that and
now those said items are showing as blank in an OutOfDate field
I am using.

Is there a way of differentiating between items that are OKAY
and those that are out of date.

Thanks


First test for "Past Due", then your /Soon Due:.

iif( NextTestDate date(),"OverDue",iif(date()= NextTestDate
+7,"Due Soon","OK"))




Thanks , but I am getting missing operand error, or more precisely

+operator, in an expression without a corresponding operand


sorry forgot some parentheses, Access was calculating the difference
between the dates, returning true or false, then adding 7.

iif( mydate date(),"OverDue",iif((myDate-date()7),"Due Soon","OK")