Forum Discussion

JeromeMitchell's avatar
JeromeMitchell
Qrew Member
2 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...
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
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
2 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
------------------------------