How can I use something like this one NOW() - INTERVAL 10 DAY
in collection filter?
->addFieldToFilter('period', ['gteq' => 'NOW() - INTERVAL 1 DAY'])
Before running the query, the value in the filter is going to be converted into a string, so MySQL will not run it as functions.
Is there any way I can use the MySql functions in a filter?