Hi,
I’ve been struggling with this one and cannot find any documentation how to achieve the following in a report
AND order_date BETWEEN date(‘now’,‘localtime’, -7*{{weeks}}||’ days’) AND date(‘now’,‘localtime’)**
i wish for my filter box to specify in weeks, but SQL does not have a weeks modifier. Therefore i must somehow use days modifier and multiply the variable entry by 7. Can you thing of the structure to achieve this? the example has no matches which is incorrect.
thanks much
Chuck