Getting data after a certain date field

[Anonymous]

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;

[#2]

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...

[Anonymous]

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?

[#4]

date(max(date)-[Last recorded date])? This might work.

It would be easier if you could share your qvw.