How to limit data so that is is greater than today

gg ⚪️

I am trying to accomplish having my limit data be greater than or equal to today.  How can I accomplish this?  Thanks



Best Answer

  • cmarkum
    cmarkum 🟢
    Answer ✓

    You can't enter a formula in the "Limit Data" on the date in the card. This would be a great idea to post in the Idea Exchange though!


    You would have to create a Beast Mode calculation and use that as a filter. 


    CASE WHEN `DATE` >=CURDATE() then 1 else 0 end


    and then just add that to the filters area and filter for 1. 


This discussion has been closed.