# Ugly Date in If-then-else

**URL:** <https://community.glideapps.com/t/ugly-date-in-if-then-else/9711>\
**Category:** Report a Bug\
**Created:** [May 25, 2020, 1:22am UTC](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711 "2020-05-25T01:22:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 25, 2020, 1:22am UTC](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/1 "2020-05-25T01:22:17Z")

</div>

My app’s URL: [checkout.glideapp.io](http://checkout.glideapp.io)

I have an app for checking out shared devices. I want to display a date in the log beneath each item. That date will either be the checkout date (if checked out) or the check in date (if checked in). When I create this logic in the if-then-else column, the resulting date/time is the ugly format. The actual date time columns are pretty and I attempted to format my sheet columns as pretty versions without luck.

![Screen Shot 2020-05-24 at 9.21.16 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2c1aa3e0d81ba44744e5e3bbe39e61ff3d535d48.png)

 ![Screen Shot 2020-05-24 at 9.21.26 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7bae6e8de8d5cf0e708e05c5c174363cddbd7cb0.png) ![Screen Shot 2020-05-24 at 9.21.38 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/108aa8edf816dcb3f546e8d7bb9c9eca8f1bdd82.png) ![Screen Shot 2020-05-24 at 9.21.47 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/7bd8cbb70010b116e0d41ceba9ac96c5c18922b2.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 25, 2020, 4:31am UTC](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/2 "2020-05-25T04:31:37Z")

</div>

I think I’ve seen the same issue with already formatted numbers and had to create a follow-up math column just to get it to format with the proper precision and dollar sign.

---

<div class="post-metadata">

**Author:** ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)\
**Post date:** [September 2, 2020, 4:14am UTC](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/3 "2020-09-02T04:14:48Z")

</div>

Hello,

I just ran into this exact issue. The IF THEN ELSE formula is not displaying the same date time format as the input columns. Did you find a solution?

Thanks!

---

<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:** [September 2, 2020, 11:33am UTC](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/4 "2020-09-02T11:33:38Z")

</div>

Usually creating a template column of the date column will “lock in” that formatting. Then you can use the template column in your if then column.

---

<div class="post-metadata">

**Author:** ![Jeremy\_P](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jeremy\_P](https://community.glideapps.com/u/Jeremy_P)\
**Post date:** [September 2, 2020, 1:54pm UTC](https://community.glideapps.com/t/ugly-date-in-if-then-else/9711/5 "2020-09-02T13:54:13Z")

</div>

That worked!! Thanks!