date comparison in set analysis

[#1]

I am looking to compare 2 date fields using set analysis. 

Date1 <= Date2 + 29 

In this example I am trying to make sure that Date1 is less than or equal to Date2 + 29 days.

My current expression is:

COUNT({<Field1={A], Field2={B} >} Products)

Now I just need to incorporate the date comparison into the above expression.

Thanks!

[MayilVahanan]

HI,

     Try like this

     COUNT({<Field1={A}, Field2={B} ,Date1 = {'<=$(=Date(Max(Date2)+29)))'}>} Products)

     Hope there is link between Date1 and Date2 fields.

     Hope it helps..

[#3]

I gave this a try but haven't been able to get it to work yet. 

[MayilVahanan]

HI,

     Can you post a sample..Did you check the report, is there any link between date1 and date2..

[CELAMBARASAN]

In which place you are going to use this expression?

[#6]

Here is my example.

[MayilVahanan]

HI,

     Use like this

     COUNT({<AssessmentID = {"=A2000>=timestamp(A1600+29)"} >} AssessmentID)

     Hope it helps.