SQL query using INTERVAL won't take variable

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