topic Re: Comparing dates with Set analysis in App Development

Comparing dates with Set analysis

victor_greffet — Mon, 30 Oct 2017 16:22:17 GMT

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 — Mon, 30 Oct 2017 16:24:07 GMT

May be this

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

victor_greffet — Mon, 30 Oct 2017 16:44:55 GMT

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 — Mon, 30 Oct 2017 16:48:22 GMT

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)