Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi swuehl,
Thank you for solution.
Warm Regards,
Ashvita Katkar.