Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
2 years ago

Jinja Help Needed

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

2 Replies

  • 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
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      Thank you for your suggestion!

      ------------------------------
      Paul Peterson
      ------------------------------