n_weeks_ago.sql

{%- macro n_weeks_ago(n, tz=None) -%}
{%- set n = n|int -%}
{{ dbt.date_trunc('week',
    dbt.dateadd('week', -1 * n,
        dbt_date.today(tz)
        )
    ) }}
{%- endmacro -%}