Jinja ISO Date format in Pipeline

Question

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 right format.Currently I'm getting: 2023-01-16 15:59:19.671000+00:00I need: 2023-01-16T15:59:19.671ZIs there a Jinja function or something I can use to make this conversion?
------------------------------Jeremy LahnersLeadBaller------------------------------

DougHenning1 · Answer

You can use strftime to specify the formatting. This should do the trick:

{{ time.now.strftime("%FT%T.%f")[:-3] ~ "Z" }}

%F date formatted as "YYYY-MM-DD"
T Literal character
%T time in 24 hour format
[:-3] strips the last three characters from the end
~ "Z" appends the letter Z to the end

------------------------------
Doug Henning
------------------------------

Sign up

Login to the community