Formula within Query to capture previous 7 days

SOLVED

Hi,

Do you know how could I amalgamate previous week from within a formula?

Trying to show what was shipped during that time frame, showing both a graph and line items.

At the moment this works from this date and future ones, [F:SOQ]EXTDLVDAT >= date$, just not sure about how to specify a range of 7 days

Thanks,