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.
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'
Then just filter to 60 or greater