Filter by date : before 6 months

Hello,

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)

:pray:

Best,

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

Hi @pascal_yespark
There's currently no relative before filter in the GUI:
https://github.com/metabase/metabase/issues/4083 - upvote by clicking :+1: on the first post
But you can use Custom Expression:
https://www.metabase.com/docs/latest/users-guide/expressions.html
Example: NOT interval([column], -180, 'day')

Thanks a lot, it's perfect :