Jinja Help Needed

Question

I am getting data from an external source via a webhook and pipeline.&nbsp; The business owner of this part of the app wants separate Date and Time fields rather than a Date/Time field.&nbsp; The external data is coming in as a timestamp.&nbsp; I'm looking for a Jinja ninja help me convert the timestamp into date and time fields.&nbsp; The external data is coming in like this:&nbsp;

2022-06-24T11:26:27-04:00Obviously the date is the first 10 characters and the time starts after "T" and the last 6 characters are the time zone offset.&nbsp; Does the date need to be reformatted, or will Quickbase handle the date formatted as it is?Your suggestions are greatly appreciated.
------------------------------Paul Peterson------------------------------

prashantmaheshw · Answer

Paul,While the JINJA expert reply , you can solve this problem with formula and arrive at two field for date and time&nbsp;To arrive at your date perfectly you can use Date Function , for time TimeofDay function&nbsp;var text a = "2022-06-24T11:26:27-04:00";Part($a,1,"T")Part($a,2,"T")------------------------------Prashant Maheshwari------------------------------

paulpeterson1 · Answer

Thank you for your suggestion!------------------------------Paul Peterson------------------------------

Forum Discussion

Jinja Help Needed