Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LoanLoss2:
Left Join (LoanLoss)
Load
acct_nbr as distinctAcct,
date(max(prod_dt)) as [Latest Recorded Date],
max(days_in_arears) as daysinarears
Resident Loans
group by acct_nbr;
What are you trying to accomplish with DaysArears? If you have [Latest Recorded Date], you can use it in set analysis within your expressions to display dates from [Latest Recorded Date] to the last date your recorded...
I want DaysArears to equal the amount of days from the last recorded date, for an account, to the latest recorded date ever recorded... does that make sense?
date(max(date)-[Last recorded date])? This might work.
It would be easier if you could share your qvw.