How to compare the days differnece between 2 dates with number?

[#1]

I have 2 date fields A & B lets say,

=Count({$<Interval(date(A)-date(B))= {'$(<=10)'}>}  ID )

please correct it, because it is giving me "ERROR IN SET EXPRESSION" at RED BRACE

[ahaahaaha]

May be

=Count({$<ID={"=Num(A)-Num(B)<=10"}>}  ID )

[Anonymous]

If you dont have the result of the Interval(Date(A)-Date(B) as a field, id suggest using count if.

Count(if(Interval(DateA-DateB)<=10,ID))

Set Analysis does not work with calculations. Unless you try create a variable for the calculation.

LET vVariable = Interval(Date(A)-Date(B))

Then Using set analysis .

Count({$<vVariable={"<=$(=10)"}>}ID)

[#4]

Thanks Ruan.

Its works.

But what I want to do is , I have to put some AND conditions,

=Count(If(Date(A) - Date(B) <= Day(10)

and(Status_Field='Complete' or Status_Field='Failed')

and (not IsNull(field2) or field2<>  0), ID))

[Anonymous]

Thats simple enough.

Count(If(Date(A)-Date(B) <= 10 and Match(Status_Field,'Complete','Failed') and NOT isnull(Field) or Field2 <>0,ID)))

Just check the brackets.  But that should be fine.

[#6]

Thanks once again.

But count is not matching , I will recheck my reference count.

Thanks!

Regards,

Shubham

[avinashelite]

Try like this

Count(If(Date(A)-Date(B) <= 10 and Match(Status_Field,'Complete','Failed') and (len(Field)>0 or Field2 <>0,ID)))