Forum Discussion

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...

JeremyLahners

Qrew Cadet

Hey Doug, this definitely got me closer, especially for DateTime fields. Now I am just struggling with separate Date and Time fields. Any suggestions on how to combine a Date and Time field into one datetime object so I can apply strftime() to it?

Date: 2023-01-17
Time: 4:00 PM
Desired Output: 2023-01-17T16:00:00Z

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

DougHenning1

Community Manager

2 years ago

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
------------------------------

PrashantMaheshw
Qrew Captain
2 years ago
@Doug Henning

[:-3] is a neat example of right slicing. Thank You .

------------------------------
Prashant Maheshwari
------------------------------
JeremyLahners
Qrew Cadet
2 years ago
Beautiful solution! Thank you so much!

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