help on below scenario?.

[gkcchowdary]

Hi

I have two fields RiskID and DATE.

I have created previous date and current date by using us. if I select one date from previous and one date from current it will give few RiskIDs .

Now I want to get the count of RiskIDs  which are not present in previous date but it present in current date.

how to implement the above requirement.

Thanks.

[YoussefBelloum]

Hi,

how did you create the previous date and current date ? on the script ? two different separated fields ?

if that's what you have, you can try this:

Count({<Previous_date-={'$(=Getfieldselections(Previous_date))'}>}RiskIDs)

[YoussefBelloum]

After making some test, I would recommend this (I don't know why)

Count({<Previous_date =- {'$(=Getfieldselections(Previous_date))'}>}RiskIDs)

the only difference is the position of the minus sign - near the equal sign, before or after

[gkcchowdary]

thanks for your reply Youssef. I will check your expression it works or not.