This content has been marked as final. Show 3 replies
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
group by acct_nbr;