Date category

Altair Forum User

Hi all

 

I´m stuck on a report to find out the category defined between 2 dates.

Any ideas?

In the second table I need to calculate the rating based in table 1.

 

   

LoanID	Start	End	Category
1000024	01/01/2015	31/07/2015	AA
1000024	01/08/2016	31/12/2016	B+
1000041	01/01/2015	31/12/2016	AA
1000041	01/01/2017	31/12/2016	AAA
1000088	01/01/2015	31/10/2016	B+
1000088	01/11/2016	31/12/2016	AA

 

   

Change doc	LoanID	Date	Rating
4000298	1000024	02/05/2015	AA
4000299	1000024	01/09/2016	B+
4000300	1000041	22/11/2016	AAA
4000301	1000088	02/01/2015	B+

 

thanks.

Robin

Altair Forum User

Hello Robin,

 

I did a blog post about this in 2012 - Greenbar Analytics - Invisible data might be helpful.

 

Best wishes,

 

Olly