Set Analysis - Date fields comparison

[wanyunyang]

Hi guys,

I want to get all Ids with Date1<=Date2 and Date1>=Date3. I'm using:

Count(distinct {<Id={"=Date1<=Date2>=Date3">}Id).

This expression is not giving correct result. Any idea how should I correct this?

Anything helps. Thank you in advance!

[sunny_talwar · Accepted solution]

Try this

Count(DISTINCT {<Id = {"=Date1<= Date2 and Date1 >= Date3"}>} Id)