# Date/Time Formatter settings don't persist to an If This\> That Column

**URL:** <https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121>\
**Category:** Report a Bug\
**Created:** [March 29, 2020, 11:48pm UTC](https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121 "2020-03-29T23:48:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ben\_Reynolds](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_reynolds/32/4638_2.png) [@Ben\_Reynolds](https://community.glideapps.com/u/Ben_Reynolds)\
**Post date:** [March 29, 2020, 11:48pm UTC](https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121/1 "2020-03-29T23:48:26Z")

</div>

Hi Team.

Seeing an issue with the Format settings for a Date/Time Column. I am a date time column as a value in an If this\> That column, but it drops all formatting when doing this. Is this as intended? I have used the same column in a Template column and the formatting persists to a template column.

 ![Screenshot 2020-03-29 at 5.38.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/22dbe32344044090173edec450d1b02f678099e2.png)  
 ![Screenshot 2020-03-29 at 5.39.51 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d8c61531fbf272286ef2e248b986663d67f788ff.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 30, 2020, 12:10am UTC](https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121/2 "2020-03-30T00:10:40Z")

</div>

This is currently a limitation.

How is your If-Then-Else column configured?

---

<div class="post-metadata">

**Author:** ![Ben\_Reynolds](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_reynolds/32/4638_2.png) [@Ben\_Reynolds](https://community.glideapps.com/u/Ben_Reynolds)\
**Post date:** [March 30, 2020, 12:29am UTC](https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121/3 "2020-03-30T00:29:55Z")

</div>

Hi Mark!

Oh I forgot to add that screenshot!

 ![Screenshot 2020-03-29 at 5.38.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/372c18a2d0349dff8406973afe06fcd3d0401156.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [March 30, 2020, 3:27am UTC](https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121/4 "2020-03-30T03:27:07Z")

</div>

I see. In Glide, formats are associated with columns, not with individual values, so the whole If-Then-Else column would have to have a single format.

I think what Glide should do is, if all the THENs and ELSEs are columns and have the same format, then that format should be used. If they don’t, but they’re all at least date/time columns, Glide should let you pick a format. In this case, `TBD` is just text, and not a date/time, which can’t share the same format with date/times. Note that none of this is implemented yes - I’m just thinking out loud.

---

<div class="post-metadata">

**Author:** ![Ben\_Reynolds](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ben_reynolds/32/4638_2.png) [@Ben\_Reynolds](https://community.glideapps.com/u/Ben_Reynolds)\
**Post date:** [March 31, 2020, 3:51am UTC](https://community.glideapps.com/t/date-time-formatter-settings-dont-persist-to-an-if-this-that-column/6121/5 "2020-03-31T03:51:52Z")

</div>

I do think that makes sense. I did find a work around for this for my use case today. I created a Template column with the date/time as the only value, then used the template column in the If\>then\>else column. Worked like a charm.
