Skip to main content
Question

Format Iso String Timestamp in Pipeline

  • October 12, 2022
  • 0 replies
  • 383 views

Forum|alt.badge.img+6
I'm making a request to the Quickbase JSON API and getting the results to use in the next Pipeline step.  I can see the field type is "timestamp" and the value is an iso date timestamp, such as "2022-10-12T17:26:42Z".  I cannot seem to format this into a readable date/time string to send in an email, or use in another step.

There are no Jinja filters that seem to work, as the Quickbase flavor of Jinja is so limited.
I cannot us strftime because it's not a date, but a text string.  There are other platforms and documentation for Jinja that refer to a filter such as: iso8601_to_time. 

For example:  (this would be great in QB Pipelines!)
{{ iso_date|iso8601_to_time|datetimeformat('%a, %B %d') }}
Any ideas?  Thanks!

------------------------------
Joel Hickok
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+6
  • Author
  • Registered
  • October 12, 2022
I'm still looking for a solution for how to work with the ISO 8601 format in a Pipeline using Jinja, but for now I am just falling back on another solution.  My alternative is to create a Formula field in the same table, and use a Formula to format the date timestamp as text.  Then the Pipeline can access the text field and use that in the Jinja template for sending emails, etc.

------------------------------
Joel Hickok
------------------------------

Forum|alt.badge.img+19
  • Qrew Cadet
  • June 24, 2024

I am attempting to do something similar.  I need to extract the date portion of a date time field.