# Template to Show Just Date from a If-Else-Then formula that returns Date

**URL:** <https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216>\
**Category:** Ask for Help\
**Created:** [August 8, 2022, 9:11am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216 "2022-08-08T09:11:41Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 8, 2022, 9:11am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/1 "2022-08-08T09:11:41Z")

</div>

Dear Community,

Just wondering how to show the Date without the time in the Template, in which the data is from IF-Else-Then Formula. Any help would be much appreciated.

 ![howToRemoveTime](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/5/358dedb0a7382a9fd0441b048d780e6406929468.jpeg)

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 8, 2022, 9:13am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/2 "2022-08-08T09:13:49Z")

</div>

The following is the template formula.

 ![Template](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/196ff8117855e4f0757efc81a053417550298052.jpeg)

All the dates used at Date Only @ Medium.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 8, 2022, 9:15am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/3 "2022-08-08T09:15:48Z")

</div>

That’s a known issue with if-then-else columns. What you have to do is create another math column _after_ the if-then-else column, and set the date format in that column.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 8, 2022, 9:21am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/4 "2022-08-08T09:21:41Z")

</div>

How do I transpose the initial If-then-else value (date with time) to the new colume with date format? Which function should i use? I would like to do this in glidetable

In google sheet it is simply = .

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 8, 2022, 9:23am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/5 "2022-08-08T09:23:23Z")

</div>

Use a Math column with no formula. Just enter something like `Date` (for example), and replace `Date` with your if-then-else column. You can then format the Math column as Date Only, and use that in your template column.

Like this:

 ![Screen Shot 2022-08-08 at 5.24.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97bd9dbdc04f4091131f807abfc92606590cff03.png)

(_That example isn’t using an if-then-else column, but the method is exactly the same)._

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [August 8, 2022, 9:30am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/6 "2022-08-08T09:30:39Z")

</div>

Awesome! Thanks!

---

<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:** [August 9, 2022, 9:31am UTC](https://community.glideapps.com/t/template-to-show-just-date-from-a-if-else-then-formula-that-returns-date/46216/7 "2022-08-09T09:31:38Z")

</div>

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