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?


Solution

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.

Solution

Hi Wei Ren Nah,


Try this:

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


Best regards