# Time Issue

**URL:** <https://community.glideapps.com/t/time-issue/61600>\
**Category:** Ask for Help\
**Created:** [May 10, 2023, 6:54pm UTC](https://community.glideapps.com/t/time-issue/61600 "2023-05-10T18:54:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tirth\_Patel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tirth_patel/32/21926_2.png) [@Tirth\_Patel](https://community.glideapps.com/u/Tirth_Patel)\
**Post date:** [May 10, 2023, 6:54pm UTC](https://community.glideapps.com/t/time-issue/61600/1 "2023-05-10T18:54:26Z")

</div>

I have attached a form within my glide app to a zapier trigger. When a person clicks submit on the form, the Zapier sends a message (an email) to another person/company that the form has been submitted. Unfortunately, in that message/email, the time appears as mentioned in the image attached. How do I convert that time format into something that is understandable to a normal human being? Just to mention, the time does appear in “June, 23rd at 4 pm,” for example, format in my glide spreadsheet, but not in the email.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52b6e19d8edbe0db59bac1df7464f7d27ffe5127.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 10, 2023, 8:49pm UTC](https://community.glideapps.com/t/time-issue/61600/2 "2023-05-10T20:49:20Z")

</div>

You can try creating a template column that replicates the date. When you do that, it actually “locks in” the formatting, so if should preserve the formatting when sending the email.

---

<div class="post-metadata">

**Author:** ![Tirth\_Patel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tirth_patel/32/21926_2.png) [@Tirth\_Patel](https://community.glideapps.com/u/Tirth_Patel)\
**Post date:** [May 11, 2023, 1:18am UTC](https://community.glideapps.com/t/time-issue/61600/3 "2023-05-11T01:18:46Z")

</div>

Thanks for replying, deeply appreciate it. Will you please be more detailed on how do I do that? How do I create that template column? and it will in glide spreadsheet, not in Zapier?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 11, 2023, 1:22am UTC](https://community.glideapps.com/t/time-issue/61600/4 "2023-05-11T01:22:09Z")

</div>

Add a new Template column to you table. Give it a value such as ‘X’. Then replace ‘X’ with the column that contains your date. I’m not sure if it will work for your problem, but it’s something to try.

---

<div class="post-metadata">

**Author:** ![Tirth\_Patel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tirth_patel/32/21926_2.png) [@Tirth\_Patel](https://community.glideapps.com/u/Tirth_Patel)\
**Post date:** [May 11, 2023, 1:40am UTC](https://community.glideapps.com/t/time-issue/61600/5 "2023-05-11T01:40:58Z")

</div>

I tried that. Didn’t work.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 11, 2023, 11:56pm UTC](https://community.glideapps.com/t/time-issue/61600/6 "2023-05-11T23:56:51Z")

</div>

Can you show us how you’re setting that up with some screenshots?