Number of Sundays :

[aveeeeeee7en]

Hi Experts,

I want to count the Difference 2 Dates based on Status one is Part Request and another one is Part Sent  working on Distinct TICKETNUMBER :

For eg. :

TICKETNUMBER	WORKSTATUS	MODIFIEDON	Sundays Coming
CD1300000294778	Part Request	6/6/2013 5:53:40 PM	1 SUNDAY coming between these 2 Dates
CD1300000294778	Parts Sent	6/10/2013 3:00:57 PM
CD1300000294778	Part Request	6/11/2013 5:30:23 PM	1 SUNDAY coming between these 2 Dates
CD1300000294778	Parts Sent	6/19/2013 3:13:57 PM
CD1300000294778	Part Request	6/19/2013 4:49:45 PM	1 SUNDAY coming between these 2 Dates
CD1300000294778	Parts Sent	6/27/2013 4:09:48 PM

Final Result = CD1300000294778 = 1+1+1 = 3 Sundays

[Gysbert_Wassenaar]

See attached qvw

[Clever_Anjos]

G Wassenaar

Wow, one of the most elegant solution I have seen.

Congrats

[aveeeeeee7en]

Sir I Appreciate your Effort. You Have a Solution for every situation. Amazing.

But when i am picking full data, it is  causing Problem.

Kindly do the Needful.

[swuehl · Accepted solution]

Seems to be a similar problem like the other week.

You should try to understand the priniciple solution, how you need to check for a change in TICKETNUMBER and how to cope with repeated WORKSTATUS. I assume you will need this skill more often in the near future.

I think all you need to to is to add the calculation for the number of sundays to the load where you've calculated ageing.