out of date items
Bob H 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"))
|