Expression help for a beginner

[Badvgood]

Hi All,



I need to write an expression that basically says the opposite of this one

<=Now()+42 And >=Now()+36

So the expression I need will be for any dates except them above.

Any help would be great and thanks in advance.

[pbaldy]

How about

> Now()+42 Or < Now()+36

[RayMilhon]

Try this: Between Now()+42 and Now()+36

[RayMilhon]

PBaldy posted just before me and his solution is better. I missed the = sign

[pbaldy]

I think Between would be the appropriate way to duplicate that expression, but unless I've misread, the goal is to get the opposite result, in other words the records NOT between those dates. I've never tried, but I suppose this might work:

Not Between Now()+36 and Now()+42

Also, note I reversed the dates to make the smaller one first. In my experience, Between will usually handle it correctly either way, but in certain circumstances will fail when the larger value is first. I just can't remember what the circumstances are.

[RayMilhon]

PBaldy is correct I misread the original question saw the <= and >= but didn't pay enough attention to the rest. missed the fact that the first part was <=42 and the second was >= 36. Need to pay more attention and not assume everybody does things the same way I do.