More than one condition in expression

[#1]

Hello,

I'm trying to count entities that fits selected daterange

Each entity record has StartDate and EndDate, I use Calendars to set vFromDate and vToDate

According to my meeds I need to Count entities that matches the criteria:

1) CloseDate > vFromDate

2) OpenDate < vToDate

I know how to write one of these two conditions:

=Count({$<OpenDate = {"<$(vToDate)"}>}EntityId)

but how to add the second condition there?

Updated:

Renamed StartDate to OpenDate

Renamed EndDate to CloseDate

[Nicole-Smith]

=Count({$<OpenDate = {">$(vFromDate)<$(vToDate)"}>}EntityId)

[#3]

Something wrong here: where is the CloseDate?

[Nicole-Smith · Accepted solution]

Oh sorry, I read the post wrong the first time:

=Count({$<CloseDate = {">$(vFromDate)"}, OpenDate = {"<$(vToDate)"}>}EntityId)

[#5]

Thank you very much!