Re: Today's date + 21 days

Graham R Seach wrote:
Yes, you're right, but I think you mean...
AND DateSent > Date() - 21

I don't think so.

DateSent + 21 < Date()

....is equivelant to...

DateSent < Date() - 21

Isn't it? If he needed a less-than before he should still need a less-than.
We're just moving the calculaton to the other side of the operator.


Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:t1syk.94$ZP4.40@xxxxxxxxxxxxxxxxxxxxxxx
Graham R Seach wrote:
WHERE Returned = 2 AND DateSent+21 < Date()

Better (performance-wise) would be...

WHERE Returned = 2
AND DateSent < Date() -21

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages

  • Re: Todays date + 21 days
    ... Graham R Seach ... Microsoft Access MVP ... DateSent + 21 < Date ...
    (microsoft.public.access.queries)
  • Re: Todays date + 21 days
    ... AND DateSent> Date- 21 ... Graham R Seach ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Todays date + 21 days
    ... go in the criteria line underneath 'Date Sent'? ... "Graham R Seach" wrote: ... AND DateSent> Date- 21 ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Todays date + 21 days
    ... go in the criteria line underneath 'Date Sent'? ... "Graham R Seach" wrote: ... AND DateSent> Date- 21 ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Actually...
    ... "Graham R Seach" wrote: ... MsgBox "Duplicate Entry" ... Microsoft Access MVP ...
    (microsoft.public.access.formscoding)