Help with Aggregate Filter

Help with Aggregate Filter


Hi Friends,

CurrDate() >= ADetails.StartDate and CurrDate() <= ADetails.EndDate

I want to filter results where CurrDate() is not >= StartDate and <= EndDate

How do i write it?


Hi Wei Ren,

Well, either like this:

not (CurrDate() >= ADetails.StartDate and CurrDate() <= ADetails.EndDate)

or like this:

CurrDate() < ADetails.StartDate or CurrDate() > ADetails.EndDate

But this is all simple boolean algebra, so perhaps you should read up on this.


Hi Wei Ren Nah,

Try this:

not (CurrDate() >= ADetails.StartDate) and ADetails.StartDate <= ADetails.EndDate

Best regards