60 days since last pmt beastmode

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.



Best Answer

  • MarkSnodgrass
    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
    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.