Now I need to add a constant "show entries, which has a expiry date till *today*". There is a Hub DB Column with a date entry which should work as the filter entry.
e.g
- Row1 has an expiry date of 12.09.2018(will be shown in the module)
- Row2 has an expiry date of 10.09.2018(won't be shown in the module, because the expiry date was yesterday)
....
I've found this topic and modified the solution for my needs. Unfortunately it doesn't work.
{% if (row['expiryDate']|datetimeformat('%Y-%m-%j')) >= (local_dt|datetimeformat('%Y-%m-%j')) %}
*LISTING*
{% endif %}
expiryDate = HubDB column name of the datepicker
datetimeformat '%Y-%m-%j' = the format how the HubDB table export(CSV/XLS) looks like.
I've also tried to change the local_dt|datetimeformat to the datetimeformat which is set in the HubSpot settings(it's set to "Germany" and the blog settings are set to "medium")...