# Display of Date & Time

**URL:** https://community.glideapps.com/t/display-of-date-time/21551
**Category:** Ask for Help
**Created:** [January 22, 2021, 3:41am UTC](https://community.glideapps.com/t/display-of-date-time/21551 "2021-01-22T03:41:41Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [January 22, 2021, 3:41am UTC](https://community.glideapps.com/t/display-of-date-time/21551/1 "2021-01-22T03:41:41Z")

</div>

Hi!

I have a few rows which are displaying the date and time differently from the others. You can see below (an example is the last one) Not sure why this is as they are typed the same as the others.

 ![start](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c5cec6177045ad4b300d23488adc53d387642d09.png)  
 ![start1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bf622fdd0bd2546d8e89d2a88df95634b5d8a34.png)

---

<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: [January 22, 2021, 3:43am UTC](https://community.glideapps.com/t/display-of-date-time/21551/2 "2021-01-22T03:43:21Z")

</div>

Yeah…this has been a bug for a while. When you pop a value into an if/then/else column, it loses its formatting.

---

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [January 22, 2021, 3:55am UTC](https://community.glideapps.com/t/display-of-date-time/21551/3 "2021-01-22T03:55:35Z")

</div>

I had a math column created for the start date and entered that instead or the calendar start date. It seems to work.

---

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [January 22, 2021, 5:11am UTC](https://community.glideapps.com/t/display-of-date-time/21551/4 "2021-01-22T05:11:03Z")

</div>

I guess it works if instead you set the second If `Start Date is on or after today`, you add Start Date in the **Else** field

Or, just add in it a math column picking **Now** date/time

Glide needs only to recognize both values are same (date/time)

---

<div class="post-metadata">

### Author: ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)
#### Post date: [January 22, 2021, 5:24am UTC](https://community.glideapps.com/t/display-of-date-time/21551/5 "2021-01-22T05:24:23Z")

</div>

Yes, I realized they have to be the same format. ‘Today’s Date’ is in long format date only, while the ‘Start Date’ was another format. Created another math column for ‘Start Date’ as long format date only. Thanks!