# Date Changes Format in Template Column **URL:** \ **Category:** Ask for Help\ **Created:** [March 11, 2021, 6:38pm UTC](https://community.glideapps.com/t/date-changes-format-in-template-column/24121 "2021-03-11T18:38:05Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 11, 2021, 6:38pm UTC](https://community.glideapps.com/t/date-changes-format-in-template-column/24121/1 "2021-03-11T18:38:05Z")
Hi, I set a date column to date only which displays properly, but when I move it over a template it changes. Any reason why this is happening? Thank you! ![date](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7b26c9c788f1097290f94d0054f25da9da1f3f86.png) ![date1d](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2b3833631c7bd8abb1b84a10549bededbaaf1827.png) ---
**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:** [March 11, 2021, 11:18pm UTC](https://community.glideapps.com/t/date-changes-format-in-template-column/24121/2 "2021-03-11T23:18:40Z")
Try adding a helper template column in between first to convert your date to a text, then use that template column in your TEMP - Last Updated column. “Helper column”: Write T, point T to the Timestamp. “TEMP - Last Updated”: Last Updated - H with H being the Helper column. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 12, 2021, 12:27am UTC](https://community.glideapps.com/t/date-changes-format-in-template-column/24121/3 "2021-03-12T00:27:02Z")
It’s now displaying as it should without doing anything. So weird, must have been a glitch. Thank you!