Forum Discussion

JeromeMitchell's avatar
JeromeMitchell
Qrew Member
3 years ago

Jinja2 Expressions for date quarter

For my pipeline file output name I'm trying to format an output report filename field based on a specific date in Jinja2. Based on that date the naming convention should include which quarter the data...
DougHenning1's avatar
DougHenning1
Community Manager
3 years ago
This Jinja should format the report title (replace reportDate with your field name):
NOTE: Edited to fix quarter formula
{% set reportDate = time.now - time.delta(months=1) -%}
{% set year = reportDate.strftime('%y') -%}
{% set qtr = (reportDate.month/3) | round(method='ceil') | int %}
{{ "Report_Q%s%s_%s" | format(qtr, year, reportDate|date_mdy) }}​

------------------------------
Doug Henning
------------------------------