Show count of id's where payment date is greater than status date

[#1]

Hi all,

Please help me solve the below scenario ASAP as I am stuck in it.

I want count of  those ID's who have status(complete) and payment_date > Status_date.

For example, I have column ID,Status(In-queue, un-processed,processed, completed), payment_date and Status_date.

ID Status           payemt_date   Status_date

1 In-queue          05/12/2016    05/29/2016

1 un-processed   05/12/2016    05/30/2016

2 processed       06/03/2016    06/01/2016

2 completed       06/03/2016    06/01/2016

3 In-queue          05/30/2016    06/01/2016

3 complete         06/03/2016    06/03/2016

4 completed       05/12/2016    05/13/2016

5 In-queue          05/03/2016    05/03/2016

5 un-processed   05/03/2016    05/03/2016

6 completed       06/03/2016    06/01/2016

7 In-queue          05/12/2016    05/13/2016

7 un-processed   05/12/2016    05/13/2016

7 completed        06/01/2016   06/03/2016

So my output will be: Count = 2.

Pls reply urgently.

Thanks in Advance.

Ashvita.

[#2]

Hi swuehl,

Thank you for solution.

Warm Regards,

Ashvita Katkar.