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







      acct_nbr as distinctAcct,

      prod_dt as prod_dt2

      Resident Loans

      where is90 = 1;