3 Replies Latest reply: Jun 3, 2014 10:52 AM by Venkata Gogineni RSS

    Getting Data on a certain date

    Ashley Navin

      I am trying to get data from a certain date. I have the [Latest Recorded Date] variable already created and working but cannot figure out how to get data thats just from that date specifically. The Tmp table is what i have been attempting but it crashes

       

      LoanLoss2:

      Left Join (LoanLoss)

      Load

      acct_nbr as distinctAcct,

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

      Resident Loans

      group by acct_nbr;

       

       

       

       

       

       

      Tmp:

      Load

      days_in_arears as Daysarears,

      If(prod_dt = date(max(prod_dt)), days_in_arears, )

      Resident Loans;