Creating Arbitrary Dates with Jinja
Hey folks, so I'm trying to find the first monday of the month in my pipeline, and I'm struggling to find a way to insert my own info to create a date to work with. Here is the beginning of my curren...
Forum Discussion
Hi, Aiden. You didn't say what your final intended output is, so I'll just give some guidance on the first issue.
FYI, this is the help page for working with dates and times: https://helpv2.quickbase.com/hc/en-us/articles/4473004144660-Transforming-your-data-
You want an absolute date, so:
{% set firstDay = time.today + time.delta(year=a.year, month=a.month, day=1) %}Be mindful that a.year and a.month exist.
Hope that helps!
------------------------------
Tim Wise
------------------------------