hubdb filter for last month/year

Anonymous — Tue, 31 Jan 2023 16:09:21 GMT

How do I get last month as a filter for a HubDB?

{% set current_month = local_dt|datetimeformat("%m") %}

{% set current_year = local_dt|datetimeformat("%y") %}

{% set previous_month = ????|datetimeformat("%m") %}

{% set previous_year = ????|datetimeformat("%y") %}

Re: hubdb filter for last month/year

Brownstephen101 — Wed, 01 Feb 2023 16:05:38 GMT

{% set current_month = local_dt|datetimeformat("%m") %}

{% set current_year = local_dt|datetimeformat("%y") %}

{% set previous_month = current_month|default(1)|int - 1 %}

{% set previous_year = current_year|int - 1 %}

{% if previous_month == 0 %}

{% set previous_month = 12 %}

{% endif %}

Test: {{ previous_month }}, {{ previous_year }}, {{ current_year }}

This should return: 1, 22, 23
since today is Feb 1, 2023

You can use those numbers as filters for the values in your query:

{{ set query = "year=" + previous_year }}

{{ hubdb_table_rows(<tableId>, query) }}

Hope that helps!

topic hubdb filter for last month/year in APIs & Integrations

hubdb filter for last month/year

Re: hubdb filter for last month/year