How to enable a 'weeks' filter when using report variables

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

Hi @crwheelr
Sounds like you’re looking for this - check the comments and related issues for workarounds: - upvote by clicking :+1: on the first post