Current Date Filter

ccpincombe

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

Johnf

@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

Johnf

@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

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!