Comparision of Date fields

[#1]

  Table1:  

Date1	Date2	ID	comment
26/05/2016	26/05/2016	200	Test
27/05/2016	27/05/2016	300	Test
8/8/2016	8/8/2016	100	Test
10/10/2016	10/10/2016	400	Test
10/12/2016	10/12/2016	500	Reject
10/13/2016	10/12/2016	500	Reject

Date1 as a dimension
Expression:Count({<where comment = Test,Date1 greater than (Date2 - 60)>} Distinct ID)

Please help me in writing the above set expression to get the below output:

  Output:  

Date1	Date2	ID	comment
5/26/2016	5/26/2016	200	Test
5/27/2016	5/27/2016	300	Test
8/8/2016	11/8/2016	100	Test

[Kushal_Chawda]

Assuming that Your dates are properly formatted (i.e not string)

=Count({<comment ={'Test'}, Date1={"=Date1>Date2-60"}>} distinct ID)

[#3]

Hi,

As per the condition what you are telling you will get all Test cases.

But your output contains 3 cases only.

Is there any other conditions.