60 days since last pmt beastmode

Golfoholic

I have a payment column called LastPmtDate, it exactly what it sounds like. What I am wanting to do is write a beastmode to be used as a filter to filter on only those that our 60 days or greater from that payment date.

MarkSnodgrass

You can use a case statement and datediff to do this:

CASE WHEN DATEDIFF(CURRENT_DATE(),`lastpmtdate`) >= 60 THEN '60 or greater'
ELSE 'less than 60'
END

Then just filter to 60 or greater

MarkSnodgrass

You can use a case statement and datediff to do this:

CASE WHEN DATEDIFF(CURRENT_DATE(),`lastpmtdate`) >= 60 THEN '60 or greater'
ELSE 'less than 60'
END

Then just filter to 60 or greater