Current Date Filter

ccpincombe
ccpincombe Member
in Charting

Can you filter date to be less/greater than today without manually updating the date range filter?

Best Answer

  • Johnf
    Johnf Contributor
    Answer ✓

    @ccpincombe you can accomplish this by writing a beastmode formula and then filtering on the formula.

     

    Example

    CASE

    WHEN TableDate > CURDATE() THEN 'Greater'

    WHEN TableDate < CURDATE() THEN 'Less'

    END

     

    Then you would filter either one and never have to update manually. 

     

    Thanks,

    Johnf

Answers

  • Johnf
    Johnf Contributor
    Answer ✓

    @ccpincombe you can accomplish this by writing a beastmode formula and then filtering on the formula.

     

    Example

    CASE

    WHEN TableDate > CURDATE() THEN 'Greater'

    WHEN TableDate < CURDATE() THEN 'Less'

    END

     

    Then you would filter either one and never have to update manually. 

     

    Thanks,

    Johnf

  • ccpincombe
    ccpincombe Member

    John, 

     

    Great suggestion! Definitely worked. 

     

    Would love if it didn't require a beast mode and were able to choose this as a filter option!

This discussion has been closed.

Categories