60 days since last pmt beastmode

Options
Golfoholic
Golfoholic Member
in Charting & Analyzer

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.


image.png


Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    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

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories