Forum Discussion

JeremyLahners's avatar
JeremyLahners
Qrew Cadet
2 years ago

Jinja ISO Date format in Pipeline

Hey experts, I am trying to use the value of a field (Date/Time or Date field) in a Pipeline to be sent to a webhook.  I need to output an ISO date but can't figure out how to convert it to the rig...
DougHenning1's avatar
DougHenning1
Community Manager
Combine the date and time with space separator, then use time.parse to parse the combined string into a  datetime value:

{% set reportDate = "2023-01-16" %}
{% set reportTime = "4:37 pm" %}
{% set reportStart = time.parse(reportDate ~ " " ~ reportTime) %}
{{ reportStart.strftime("%FT%T.%f")[:-3] ~ "Z" }}



------------------------------
Doug Henning
------------------------------
JeremyLahners's avatar
JeremyLahners
Qrew Cadet
2 years ago
Beautiful solution!  Thank you so much!

------------------------------
Jeremy Lahners
LeadBaller
------------------------------