Fiscal Quarter Issue

[#1]

Hi Friends,

I have different quarter range, it is basically based on day,for eg

QTR	Start	End
1	11/25	02/16
2	02/17	05/11
3	05/12	08/31
4	09/02	11/24

and I need to map dates in above range,please find the attachment to help me in this

its really urgent.

regards

Bhawna

[#2]

please anyone,i really need the solution

[#3]

anyone please look into this

[francoiscave]

Hi Bhawna,

See the link below:

IntervalMatch

Good luck,

François

[#5]

I already applied interval match but didnt work

[#6]

I really need the solution or any alternative..

[francoiscave]

I try something...

“If there is no solution to the problem then don't waste time worrying about it. If there is a solution to the problem then don't waste time worrying about it.”

François

[tresesco]

When you write: Date#('02/31','MM/DD'), then year is taken as 1899, that is where it is going wrong. See the modified sample attached.

[anbu1984]

Mstr:

load *,

Date#(Key,'MM/DD/YYYY') as Newkey

;

load * Inline [

Key

02/01/2014,

06/03/2013

];

tab:

load * ,

date#(start,'MM/DD/YYYY') as S,

date#(end,'MM/DD/YYYY') as E;

load * Inline [

ID,start,end

1,11/25/2013,02/16/2014

2,02/17/2014,05/11/2014

3,05/12/2014,08/31/2014

4,09/02/2014,11/24/2014

1,11/25/2012,02/16/2013

2,02/17/2013,05/11/2013

3,05/12/2013,08/31/2013

4,09/02/2013,11/24/2013

];

Inner Join

IntervalMatch(Newkey) LOAD S,E Resident tab;

[#10]

thank to all of you I have told the client that it is not possible dynamically..waiting for their response..

Thank you

regards

Bhawna