Using Dropdown values as date filter

[joostschuur]

I just ran into what might have been your problem too and solved it.

See my answer on how to explicitly cast the drop down value to an interval:

DATE("publishedAt") > NOW() - {{new_videos_days.value}}::INTERVAL