Comparing dates with Set analysis

[victor_greffet]

Hi community !

I found several topics on the subject but nothing to solve my problem...

In my app i wanted to compare two fields as a condition by using Set analysis :

rangesum( above( Count({$<

DateType={'CompanyApproved'},

{[Authorized_by_company]=<[Approved_by_company]}

>} ID)

but it's not working ...

Do you have an idea ?

Thank you,

Victor

[sunny_talwar]

May be this

Count({$<DateType = {'CompanyApproved'}, ID = {"=[Authorized_by_company]=<[Approved_by_company]"}>} ID)

[victor_greffet]

Thank you for your answer Sunny,

Unfo it's still not working...

I think i have to load another field in the script like

if( [Authorized_by_company]<=[Approved_by_company],'<=','') as comparison

and then

Count({$<DateType = {'CompanyApproved'}, Comparison={'<='}}>} ID) ... is the wording correct?

[sunny_talwar · Accepted solution]

I would just to this

If([Authorized_by_company] <= [Approved_by_company], 1, 0) as comparisonFlag

and then this:

Count({$<DateType = {'CompanyApproved'}, comparisonFlag = {1}>} ID)