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
------------------------------
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago
absolutely amazing Doug ! On my basic testing on live parser

it's not able to parse 
 reportDate|date_mdy

Below seem to work. What could I be doing wrong @Doug Henning

{% set year = reportDate.strftime('%y') -%}
{% set qtr = (reportDate.month / 3) | int -%}
{{ "Report_Q%s%s_%s" | format(qtr, year, reportDate.strftime('%Y-%m-%d')) }}​​


------------------------------
Prashant Maheshwari
------------------------------
  • DougHenning1's avatar
    DougHenning1
    Community Manager
    3 years ago
    Hi @Prashant Maheshwari, glad it was helpful!  The filter `date_mdy` is a custom filter by Quickbase so it won't work in other environments like live parsers.  Nice job of figuring out a workaround- you're becoming a Jinja master!
    ​​

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