# Why Template Column Not Display properly **URL:** \ **Category:** Ask for Help\ **Created:** [August 27, 2021, 7:50am UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022 "2021-08-27T07:50:27Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 7:50am UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/1 "2021-08-27T07:50:27Z")
Hi, I have been trying to do date conversion in Glide Table (GT) using necessary columns such split, single value, maths and template. In the final template, I can see I have the data as I wanted, BUT when display in the APP I only get “AMTZ”. See photos…Appreciate any insight. Thanks. ![template](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6661c8f6db760143809c571a11cda3fa855528c.jpeg) _Template looks ok on screen_ ![template1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94e31fee5e8bc1f2c5056dee53c0f123b57e667d.jpeg) “Display value in APP is AMTZ” ---
**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:** [August 27, 2021, 1:38pm UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/2 "2021-08-27T13:38:34Z")
Can you show how your template column is set up? ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 3:25pm UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/3 "2021-08-27T15:25:50Z")
Thanks @Jeff_Hager Below is template column setup ![template2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/0890fe924ae5bc72f8cafd7ba53e17c8f65b40a3.jpeg) Basically I took the original date did various operations that are needed such as split and put them back. Below is just a few operational columns ![template2a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b36775b4f41d3724aeeabdd1ee9255d67138385.jpeg) ---
**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:** [August 27, 2021, 5:21pm UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/4 "2021-08-27T17:21:57Z")
That’s really weird. I’m just not seeing how that becomes AMTZ from that template. Would you be able to create a copyable sample app with the same issue, or maybe duplicate your current app and strip it down to just that date part that doesn’t work. I think I’d like to see a copy to see if I can figure out what’s happening. I can understand where the T and Z come from in AMTZ, but I just don’t get the A and M part. ---
**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:** [August 27, 2021, 11:29pm UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/5 "2021-08-27T23:29:17Z")
Weird how it comes out, but AM might come from an AM/PM format (stored in a date/time long format I think). ---
**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:** [August 27, 2021, 11:44pm UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/6 "2021-08-27T23:44:41Z")
Ah, that makes a lot of sense. Didn’t think about that. Maybe something gets formatted differently somewhere and all of the single values on the split get thrown off. Maybe instead of Splits and picking out the pieces that way…it might be better to use a series of math columns that pull out each part and then put it back together in a template. YEAR(date), HOUR(date), etc. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 28, 2021, 3:42am UTC](https://community.glideapps.com/t/why-template-column-not-display-properly/31022/7 "2021-08-28T03:42:05Z")
Understood now. Thanks