How to set expression for field comparsion?

[Anonymous]

Hi All,

From	To	Date
1/18/2016	12/12/2016	3/3/2016
2/14/2016	1/17/2017	1/1/2015
3/14/2016	4/1/2016	2/6//2016
4/19/2016	7/7/2017	7/7/2016

I would like to count the number of record where date > from  and date < to in the pivot table with dimension month(date)&year(date)

Many Thx!

Best Regards,

Louis

[sunny_talwar]

What if there is not unique field such as RowNum

Also, you were always the biggest advocate of doing this kind of stuff in the script, What changed ?

[vinieme12]

LOL, I know

[ahaahaaha]

If you do not in the script, so try

Count({<Date = {"=Date>=From"}>*<Date = {"=Date<=To"}>}Date)

I it works

[Anonymous]

I tried other approaches but fail and i dont know why

So I try yours and success.

Many Thx!