Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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..
I gave this a try but haven't been able to get it to work yet.
HI,
Can you post a sample..Did you check the report, is there any link between date1 and date2..
In which place you are going to use this expression?
Here is my example.
HI,
Use like this
COUNT({<AssessmentID = {"=A2000>=timestamp(A1600+29)"} >} AssessmentID)
Hope it helps.