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...
Forum Discussion
This Jinja should format the report title (replace reportDate with your field name):
NOTE: Edited to fix quarter formula
------------------------------
Doug Henning
------------------------------
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
------------------------------
- absolutely amazing Doug ! On my basic testing on live parser
it's not able to parsereportDate|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
------------------------------- 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
------------------------------
- I don't have an actual field name called reportDate. So I just did everything in the report filename field. I was using {{(time.now - time.delta(months=1)).strftime('%m%d%y') as the value of the "reportDate" field in my original example.
The only real problem I have is for the quarter value, it is coming back as 4.0 instead of just 4, how can I get rid of the decimal point ?
Thanks for you assistance.
------------------------------
Jerome Mitchell
------------------------------- You had the ')' before '.month' instead of after it, so the 'int' filter wasn't getting applied to the final value. Also, the formula I posted didn't always produce the correct result. Here's the corrected version with your dates cleaned up:
{% set reportDate = time.now - time.delta(months=1) -%} {% set year = reportDate.strftime('%y') -%} {% set qtr = (((reportDate.month - 1) / 3) + 1) | int -%} {{ "Report_Q%s%s_%s" | format(qtr, year, reportDate|date_mdy) }}
------------------------------
Doug Henning
------------------------------- Thanks, this worked great. Just had a minor question. in the qtr logic :
{% set qtr = (((reportDate.month - 1) / 3) + 1) | int -%}
can you explain the (((report.Date.month -1) /3) +1) part? why do you minus 1 then divide by 3 and add 1 again.
Thanks
------------------------------
Jerome Mitchell
------------------------------
