2 Replies Latest reply: Jan 26, 2017 2:50 PM by Robbin James RSS

    Date category

    Robbin James

      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.

       

         

      LoanIDStartEndCategory
      100002401/01/201531/07/2015AA
      100002401/08/201631/12/2016B+
      100004101/01/201531/12/2016AA
      100004101/01/201731/12/2016AAA
      100008801/01/201531/10/2016B+
      100008801/11/201631/12/2016AA

       

         

      Change docLoanIDDateRating
      4000298100002402/05/2015AA
      4000299100002401/09/2016B+
      4000300100004122/11/2016AAA
      4000301100008802/01/2015B+

       

      thanks.

      Robin