3 Replies Latest reply: May 29, 2014 2:28 PM by Ashley Navin RSS

    Earliest Date

    Ashley Navin

      So I am creating a table that displays account numbers and certain dates that correspond with the account number. I am wondering how to only display the earliest date for each account number as opposed to every date for each account number.

       

      Tried using min and firstvalue and couldnt get either to work

       

       

       

      LoanLoss:

       

      LOAD

      acct_nbr as distinctAcct,

      prod_dt as prod_dt2

      Resident Loans

      where is90 = 1;