# Different Date formats Wanted in Different Tab

**URL:** <https://community.glideapps.com/t/different-date-formats-wanted-in-different-tab/16872>\
**Category:** Ask for Help\
**Created:** [October 7, 2020, 12:19pm UTC](https://community.glideapps.com/t/different-date-formats-wanted-in-different-tab/16872 "2020-10-07T12:19:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\
**Post date:** [October 7, 2020, 12:19pm UTC](https://community.glideapps.com/t/different-date-formats-wanted-in-different-tab/16872/1 "2020-10-07T12:19:50Z")

</div>

It seems like this would be easy, but I cannot find a solution.

On one tab I want a long Date format: Wednesday, October 7, 2020  
This one is coming right into the sheet with a form.

On another tab, I want a shorter one 10/07/2020.  
I have a relation and lookup pulling in the date from the first sheet.

How do I get the looked up dates into the shorter format?

Whenever I change the original, the looked up ones change.

Any ideas?

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [October 7, 2020, 12:24pm UTC](https://community.glideapps.com/t/different-date-formats-wanted-in-different-tab/16872/2 "2020-10-07T12:24:36Z")

</div>

Hey @spencersRus,

This is just an idea, I haven’t tried it myself.

How about having two math columns one for the long format and another one for the short one. Maybe use a template to lock it in and have the lookup find the short format. I believe that it might keep the formatting in the second math column whenever you change the original one.

I hope this helps.

Santiago.

---

<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:** [October 7, 2020, 12:46pm UTC](https://community.glideapps.com/t/different-date-formats-wanted-in-different-tab/16872/3 "2020-10-07T12:46:35Z")

</div>

Santiago is correct. A math column to duplicate the original column with a new format will work, but people have problems with lookup on datetime columns before so beware.