Filter by date : before 6 months


In a question, I would like to display all items with a date field before 6 months from now.

Currently when using "Before" I can only choose a fixed date :

Do you have any idea on how to do this ? (without switching to SQL mode)



Hey @pascal_yespark
In that case I would use
Previous 6 months in the dynamic date filter :slight_smile:

Hi @pascal_yespark
There's currently no relative before filter in the GUI: - upvote by clicking :+1: on the first post
But you can use Custom Expression:
Example: NOT interval([column], -180, 'day')

Thanks a lot, it's perfect :