# 🤔How to: Stop and IF THEN ELSE column from showing the time (w/ pic)

**URL:** <https://community.glideapps.com/t/how-to-stop-and-if-then-else-column-from-showing-the-time-w-pic/64360>\
**Category:** Ask for Help\
**Created:** [July 25, 2023, 6:28pm UTC](https://community.glideapps.com/t/how-to-stop-and-if-then-else-column-from-showing-the-time-w-pic/64360 "2023-07-25T18:28:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\
**Post date:** [July 25, 2023, 6:28pm UTC](https://community.glideapps.com/t/how-to-stop-and-if-then-else-column-from-showing-the-time-w-pic/64360/1 "2023-07-25T18:28:31Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/b/6b9b166c7e195fad88e2289b478b11b24582e635.png)  
Hello!

My If then Else column IS working, however it displays the time despite none of the other factors being set to date AND time.

How can i work around this?

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:** [July 25, 2023, 7:51pm UTC](https://community.glideapps.com/t/how-to-stop-and-if-then-else-column-from-showing-the-time-w-pic/64360/2 "2023-07-25T19:51:07Z")

</div>

It’s showing the raw underlying value of the date column. Create a template column with a value such as ‘X’ and replace ‘X’ with your date column value. That will “lock it in” as a text string.

Or, a better solution would be to try adding a math column, which takes the result from the IF column and reformats it.

---

<div class="post-metadata">

**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\
**Post date:** [July 25, 2023, 10:48pm UTC](https://community.glideapps.com/t/how-to-stop-and-if-then-else-column-from-showing-the-time-w-pic/64360/3 "2023-07-25T22:48:07Z")

</div>

> [@Jeff\_Hager](#):
>
> Or, a better solution would be to try adding a math column, which takes the result from the IF column and reformats it.

Thank you! This worked! Much appreciated!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 26, 2023, 10:48pm UTC](https://community.glideapps.com/t/how-to-stop-and-if-then-else-column-from-showing-the-time-w-pic/64360/4 "2023-07-26T22:48:12Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.