4 Replies Latest reply: Oct 30, 2013 6:20 PM by Stefan Wühl

# Number of Sundays :

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

• ###### Re: Number of Sundays :

See attached qvw

• ###### Re: Number of Sundays :

gwassenaar

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

Congrats

• ###### Re: Re: Number of Sundays :

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.

• ###### Re: Re: Re: Number of Sundays :

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.