Skip to main content
Question

Jinja Help Needed

  • June 24, 2022
  • 0 replies
  • 55 views
I am getting data from an external source via a webhook and pipeline.  The business owner of this part of the app wants separate Date and Time fields rather than a Date/Time field.  The external data is coming in as a timestamp.  I'm looking for a Jinja ninja help me convert the timestamp into date and time fields.  The external data is coming in like this: 
2022-06-24T11:26:27-04:00

Obviously the date is the first 10 characters and the time starts after "T" and the last 6 characters are the time zone offset.  Does the date need to be reformatted, or will Quickbase handle the date formatted as it is?

Your suggestions are greatly appreciated.


------------------------------
Paul Peterson
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+11
Paul,

While the JINJA expert reply , you can solve this problem with formula and arrive at two field for date and time 

To arrive at your date perfectly you can use Date Function , for time TimeofDay function 
var text a = "2022-06-24T11:26:27-04:00";
Part($a,1,"T")


Part($a,2,"T")

------------------------------
Prashant Maheshwari
------------------------------
Terms & ConditionsAccessibility statement