Earliest Date

[Anonymous]

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;

[Anonymous]

The min() function should work.  You're missing something...  Can you upload your QV file?

[eduardo_sommer · Accepted solution]

Try this

LoanLoss:

Load

acct_nbr as distinctAcct,

date(min(prod_dt)) as prod_dt2

Resident Loans

where is90 = 1

group by acct_nbr;

Eduardo

[Anonymous]

This worked! Thank you!