For products you can use the following sqlfilter:
(t.datec:>=:'2022-11-13' and t.datec <'2022-11-16')
Syntax described in ~/htdocs/core/lib/functions.lib.php
→ function forgeSQLFromUniversalSearchCriteria(…)
// Must be (aaa:bbb:…) with aaa is a field name (with alias or not) and bbb is one of this operator ‘=’, ‘<’, ‘>’, ‘<=’, ‘>=’, ‘!=’, ‘in’, ‘notin’, ‘like’, ‘notlike’, ‘is’, ‘isnot’
