Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Oh sorry, I read the post wrong the first time:
=Count({$<CloseDate = {">$(vFromDate)"}, OpenDate = {"<$(vToDate)"}>}EntityId)
=Count({$<OpenDate = {">$(vFromDate)<$(vToDate)"}>}EntityId)
Something wrong here: where is the CloseDate?
Oh sorry, I read the post wrong the first time:
=Count({$<CloseDate = {">$(vFromDate)"}, OpenDate = {"<$(vToDate)"}>}EntityId)
Thank you very much!