Adjust dates in Quickbase Pipelines using Jinja

Relative dates are used all the time, so why not use them in Pipelines!

For example, add a task to a project that has a due date of 2 days from the project start date.

Or set a next payment due date for the first of the month following receipt of this month's payment.

Or maybe you just need to set the end time for a meeting 1 hour after the start.

By adding Jinja to your Pipeline, you can take an initial date or date/time value and derive a new 'adjusted' time value.

With 2 Jinja functions, it's possible to...
㊙️ Add or subtract days, months, or years from today
㊙️ Add or subtract days, months, or years from another date
㊙️ Add or subtract hours, minutes, or seconds from any date/time
㊙️ Replace one or more values in a date with a specific month, day, or year
㊙️ Replace one or more values in a time with a specific hour, minute or second

The Jinja Functions
㊙️ Used to offset a date/time value by a specified amount of time, such as hours, days, or months.

.replace()
㊙️ Replaces the day, month, or year in a date value or hour, minute, and second in a date/time value.

A Few Examples
Add 3 hours to the Current Time

With an adjustment for timezone:

Add 3 days to a Start Date field from step A in the Pipeline

Adjusting for both days and months:

Add 1 month to a Due Date field and set the date to the 1st

Be sure to watch the video for more examples and tips.

These date/time adjustments are sure to come in handy!

RESOURCES:

Feeling like a Junkie? Subscribe Now!

LET'S CONNECT!

© Quick Base Junkie

Quick Base Junkie is unofficial and not affiliated with Quickbase Inc.

[ivanjay]

So helpful, what about if we need to add "workdays"? I need to add (5) days but want to stay on weekdays only