Quick Base Junkie Blog

Short videos and posts to skyrocket your Quickbase skills!

Get tips in your inbox

Join the Quick Base Junkie Community email list!

Time Zone Troubles? Fix it with Jinja in Quickbase Pipelines

advanced how to intermediate jinja pipelines Jun 09, 2021

>> Get the Jinja Date & Time Cheat Sheet <<

This demo predates the new Pipeline Designer. For writing Jinja, the process is similar, but you'll need to click on the </> code icon first. To follow along in the old designer, toggle OFF the "Pipeline Designer" at the top of the screen.

Accessing the current date/time in Pipelines using Jinja can be SUPER helpful, but if you don't convert it to your local time zone... it can be SUPER frustrating.

When using the {{ time.now }} Jinja template, you may not immediately notice that you have a time zone issue.

For me on Pacific Time, I'm currently 7 hours behind the UTC time that this template returns... so it's only after 5 PM that I start having issues (when referencing just the date).

Basically, any pipeline running after 5 PM time will use the next day's values 😱

This is a problem. (read more about it)

We can fix this with the Jinja timezone filter.

Apply Time Zones, such as:

Eastern
Central
Mountain
Pacific
Plus many more!

How to use the Jinja timezone filter

To add the timezone filter to your {{ time.now }} templates you'll include a "pipe" symbol followed by the 'timezone' function and then the properly formatted time zone within a set of parentheses and single quotations.

Here are several common examples: