60 days since last pmt beastmode

Golfoholic · 2021-12-31T21:31:47+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Filters

Card Builder

Accepted answers

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

All comments

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of