Getting Data on a certain date

[Anonymous]

I am trying to get data from a certain date. I have the [Latest Recorded Date] variable already created and working but cannot figure out how to get data thats just from that date specifically. The Tmp table is what i have been attempting but it crashes

LoanLoss2:

Left Join (LoanLoss)

Load

acct_nbr as distinctAcct,

date(max(prod_dt)) as [Latest Recorded Date]

Resident Loans

group by acct_nbr;

Tmp:

Load

days_in_arears as Daysarears,

If(prod_dt = date(max(prod_dt)), days_in_arears, )

Resident Loans;

[#2]

Hi Ashley

If(prod_dt = date(max(prod_dt)), days_in_arears )   comma not needed if there is no default value.

but what you can do is use EXISTS like

Load

days_in_arears as Daysarears

Resident Loans

WHERE EXISTS([Latest Recorded Date], days_in_arears)     // Will take records only if dates match

;

best regards

chris

[Anonymous]

This crashes the program. Thank you though

[venkatg6759]

Try this

Tmp:

Load

days_in_arears as Daysarears,

Resident Loans Where prod_dt=[Latest Recorded Date];