Answering my own question, the tricks seems to be to caste it with ::INTERVAL in the query:
DATE("publishedAt") > NOW() - {{new_videos_days.value}}::INTERVAL
...and then use a value of 7 days e.g..
4 Likes