Forum Discussion

WillisTaylor1's avatar
WillisTaylor1
Qrew Trainee
9 months ago

Date and Time Field Output in Outlook Pipeline

I currently have a Date and Time Field, I want to insert into a Outlook pipeline. Is there way to show only the date and time versus the date and time + 00:00 Below is the line in the inserted in body of the email and the output

<p> Invoice order for {{a.event_date}} </p>

Invoice order for 2024-01-18 18:00:00+00:00 



------------------------------
Willis Taylor
------------------------------
  • Figured it out. Create a formula field to convert Date and Time to text. Called that field in the pipeline. 



    ------------------------------
    Willis Taylor
    ------------------------------
    • ChayceDuncan's avatar
      ChayceDuncan
      Qrew Captain

      In the future you can also use strftime to convert and display date values in certain formats



      ------------------------------
      Chayce Duncan
      ------------------------------
      • WillisTaylor1's avatar
        WillisTaylor1
        Qrew Trainee

        Awesome thank you



        ------------------------------
        Willis Taylor
        ------------------------------