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..
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..