out of date items
in [Form]
|
From: Bob Quintal on 15 May 2010 12:21 Bob H <bob(a)despammer.com> wrote in news:LNGdnXHUxNVHKnPWnZ2dnUVZ7vqdnZ2d(a)giganews.com: > 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"))
From: Bob H on 15 May 2010 13:40 On 15/05/2010 17:21, Bob Quintal wrote: > Bob H<bob(a)despammer.com> wrote in > news:LNGdnXHUxNVHKnPWnZ2dnUVZ7vqdnZ2d(a)giganews.com: > >> 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
From: Bob Quintal on 15 May 2010 14:52 Bob H <bob(a)despammer.com> wrote in news:Fu2dnTRYIpAGQXPWnZ2dnUVZ8qadnZ2d(a)giganews.com: > On 15/05/2010 17:21, Bob Quintal wrote: >> Bob H<bob(a)despammer.com> wrote in >> news:LNGdnXHUxNVHKnPWnZ2dnUVZ7vqdnZ2d(a)giganews.com: >> >>> 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")
From: Bob Quintal on 15 May 2010 14:58 Bob Quintal <rquintal(a)sPAmpatico.ca> wrote in news:Xns9D79975675D5BQuintal(a)69.16.185.250: > Bob H <bob(a)despammer.com> wrote in > news:Fu2dnTRYIpAGQXPWnZ2dnUVZ8qadnZ2d(a)giganews.com: > >> On 15/05/2010 17:21, Bob Quintal wrote: >>> Bob H<bob(a)despammer.com> wrote in >>> news:LNGdnXHUxNVHKnPWnZ2dnUVZ7vqdnZ2d(a)giganews.com: >>> >>>> 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") > oops, change mydate to NextTestDate in both places.
From: Bob H on 15 May 2010 15:30 On 15/05/2010 19:58, Bob Quintal wrote: > Bob Quintal<rquintal(a)sPAmpatico.ca> wrote in > news:Xns9D79975675D5BQuintal(a)69.16.185.250: > >> Bob H<bob(a)despammer.com> wrote in >> news:Fu2dnTRYIpAGQXPWnZ2dnUVZ8qadnZ2d(a)giganews.com: >> >>> On 15/05/2010 17:21, Bob Quintal wrote: >>>> Bob H<bob(a)despammer.com> wrote in >>>> news:LNGdnXHUxNVHKnPWnZ2dnUVZ7vqdnZ2d(a)giganews.com: >>>> >>>>> 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") >> > oops, change mydate to NextTestDate in both places. Thanks, but now getting invalid syntax error message: You may have entered an operand without an operator
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 4 Prev: Wizard unable to open form in Form or Datasheet view Next: Pivot table form |