3 Replies Latest reply: Jun 2, 2014 12:27 PM by Jacob Kean RSS

    Getting data after a certain date field

    Ashley Navin

      So Im trying to extract data after the [Latest Recoded Date] field. I want a number of days since that date but don't know how to specify that it MUST be from after that date.


      I have the [Latest Recorded Date] variable stored and ready to use I'm just not sure how to write that i want a variable called DaysArears that starts from that date til the latest date ever recorded





      Left Join (LoanLoss)


      acct_nbr as distinctAcct,

      date(max(prod_dt)) as [Latest Recorded Date],

      max(days_in_arears) as daysinarears

      Resident Loans

      group by acct_nbr;