# Date Format Effect after addition scenarios in If-Else Column

**URL:** <https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586>\
**Category:** Ask for Help\
**Created:** [September 5, 2022, 1:08am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586 "2022-09-05T01:08:50Z")\
**Posts on this page:** 6\
**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:** [September 5, 2022, 1:08am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586/1 "2022-09-05T01:08:50Z")

</div>

Dear Community,

I am not sure the reason why the Data format is affected when adding another scenario.

Before:

 ![b](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8fde605f2a32e3328c9ff844a3e342668d030b74.jpeg)

After Adding:

 ![when add this date format is scrambled](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/381d4ec954aaa50066aa8cfbc7cae83117b1e563.png)

1. All the dates are set as Medium showing dates only (throughout the app)
2. How can we assure that the format be constant?

Thanks in advance.

---

<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:** [September 5, 2022, 1:11am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586/2 "2022-09-05T01:11:52Z")

</div>

It’s a known issue.

The workaround is to add a math column after the if-then-else column, and use that to reset the format.

You don’t need a formula in the math column, just enter something like D, and replace that with the if-then-else column value.

---

<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:** [September 5, 2022, 1:32am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586/3 "2022-09-05T01:32:16Z")

</div>

Awesome! Thanks for the tips!!

Can template works the same?

Btw, with so many additional columns just to get the effect, will overall performance (speed) be affected?

---

<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:** [September 5, 2022, 1:44am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586/4 "2022-09-05T01:44:35Z")

</div>

> [@ichilddev](#):
>
> Can template works the same?

No, a template won’t work in this case. Try it and you’ll see what happens 😉

> [@ichilddev](#):
>
> Btw, with so many additional columns just to get the effect, will overall performance (speed) be affected?

Generally, no.  
It just depends. There can be extreme cases where computed columns can contribute to poor performance. But as a general rule, it’s not something that you need to worry about. I have apps with thousands of computed columns, and they perform just fine.

---

<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:** [September 5, 2022, 2:42am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586/5 "2022-09-05T02:42:16Z")

</div>

Thanks for your advice! Appreciate!

---

<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:** [September 6, 2022, 2:42am UTC](https://community.glideapps.com/t/date-format-effect-after-addition-scenarios-in-if-else-column/48586/6 "2022-09-06T02:42:25Z")

</div>

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