# Different representations of same Date column

**URL:** <https://community.glideapps.com/t/different-representations-of-same-date-column/32155>\
**Category:** Ask for Help\
**Created:** [September 22, 2021, 4:09pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155 "2021-09-22T16:09:50Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 22, 2021, 4:09pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/1 "2021-09-22T16:09:50Z")

</div>

Hi guys,  
Is there a way to have a column with e.g. Time only component from the Date&Time column?  
E.g. for business operations, I need full date-time, for displaying - I would like to have time only, or date in full format(not short).

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [September 22, 2021, 4:12pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/2 "2021-09-22T16:12:40Z")

</div>

I did a YC with this option

> [@Date Conv](https://community.glideapps.com/t/date-conv/31894):
>
> Hello, Here is a script (for a special case stuck_out_tongue_closed_eyes) to display a date in a custom language and format. The idea is if the user is using a browser (for example in English) and you want to display the dates in another language. The return date is in text format, therefore intended for display. You can also display only the day or the month or the day and date,…. This can be used for multi-language applications. YC Link [https://date-conv.manun2.repl.co/](https://date-conv.manun2.repl.co/) Y…

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 22, 2021, 4:15pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/3 "2021-09-22T16:15:42Z")

</div>

Thanks, Manu,  
Yep, YC allows to do this,  
but I want to get rid of YC columns as we all find them unstable during commits and edits, and when use in ITE columns.

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 22, 2021, 4:16pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/4 "2021-09-22T16:16:32Z")

</div>

Maybe some format of Math/Template column can do this?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [September 22, 2021, 4:30pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/5 "2021-09-22T16:30:04Z")

</div>

Hola

Can you give us some examples?

Try to think some ideas but I’d rather to see your examples first. I use this coding to work with dates/times to compare, sort and filter dates/times

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27e42f481fe3731d339e7cd348b988ad27519d13.png)

but again, I don’t know if this is what your are looking for.

Saludos…

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 22, 2021, 10:00pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/6 "2021-09-22T22:00:58Z")

</div>

I have following tab:

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

Dates are real(with date and time), but here to preserve space and cos it’s obvious that it’s today I use only time part.  
In other places or as details, I want to show the full date and time.

So, the question is: how to avoid having clone date columns with the same date and just with a different format?

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [September 22, 2021, 10:44pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/7 "2021-09-22T22:44:28Z")

</div>

I do this a lot and I just end up creating multiple Math columns to pull out elements from a main Date/Time column.

Also, that layout looks awesome with the vertical progress images. How did you make that?

---

<div class="post-metadata">

**Author:** ![BlakeWS](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/blakews/32/24377_2.png) [@BlakeWS](https://community.glideapps.com/u/BlakeWS)\
**Post date:** [September 22, 2021, 10:55pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/8 "2021-09-22T22:55:23Z")

</div>

I expanded on what @gvalero did and what @kyleheney is mentioning to see it for myself. The downside being that what you get is no longer a valid time value that can be used for math etc.  
This is great, thanks Gliders!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/11f4cb35f71b24782e1ad50843ab603db5c75406.png)

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 23, 2021, 4:19am UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/9 "2021-09-23T04:19:51Z")

</div>

Okay, ended up with Experimental Code column and simple echo-date function ([https://glide-echo-date.maximkm.repl.co](https://glide-echo-date.maximkm.repl.co)).  
Experimental Code has new Date settings block for output, so simply echoing date I still have valid Date column, but can produce as many date formats as I want:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/4975fdf0b507a3af0bc81d35a647100ef3d5f0f8.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a01e4f6f0e79f0449b0b39a6c439c642442959e.png)

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 23, 2021, 4:20am UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/10 "2021-09-23T04:20:31Z")

</div>

It’s inline list with heavy CSS formatting 🙂

---

<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 23, 2021, 4:28am UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/11 "2021-09-23T04:28:16Z")

</div>

Maybe I’m missing something, but if the goal is to take a date/time and present it as time only, then a simple math column will do that…

 ![Screen Shot 2021-09-23 at 12.26.43 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f3ade858cfb9f78105b68922de79273eaac021a.png)

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 23, 2021, 4:30am UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/12 "2021-09-23T04:30:49Z")

</div>

Finally, yep, this is what I was asking 🙂 Thought that Math always returns Number. But here it goes. My function could be sent to trash then 🙂

---

<div class="post-metadata">

**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\
**Post date:** [September 23, 2021, 4:46am UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/13 "2021-09-23T04:46:10Z")

</div>

how to have interface like this

---

<div class="post-metadata">

**Author:** ![Maxim\_KM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxim_km/32/29274_2.png) [@Maxim\_KM](https://community.glideapps.com/u/Maxim_KM)\
**Post date:** [September 23, 2021, 6:50am UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/14 "2021-09-23T06:50:55Z")

</div>

Custom solution that’s not tested well in other environments.

Inline List with CSS and prepared icons as images for items.  
And List should have Title, Details, and Caption defined.

```auto
<pre><span><style>

[data-test="list-item"].separator::after {
display: none;
}

[data-test="list-item"] .horizontalTextContainer +* {
display: none;
}

[data-test="list-item"]{
padding-top:3px;
padding-bottom:3px;
padding-left:6px;
padding-right:6px;
}
[data-test="list-item-image"]{
order:-1;
margin-right:0px !important;
margin-left:0px !important;
align-self: stretch;
}
[data-test="app-vertical-list"]{
padding-bottom:0px;
}
[data-test="app-vertical-list"]::before{
content:'';
position:absolute;
border-left: 2px solid #ccc;
height:calc(100% - 26px);
top: 26px;
left: 36px;
z-index:-1;
}
div.textContainer{
align-self:start;
padding-top:6px;
}
[data-test="list-item-subtitle"]{
white-space:pre-wrap !important;
}
[data-test="list-item-title"]{
width: calc(100% - 48px);
white-space:pre-wrap !important;
}
[data-test="list-item-caption"]{
position:absolute;
top:3px;
right:10px;
font-size:1rem !important;
font-weight:bold !important;
color:#333 !important;
text-alignment:right;
white-space:pre-wrap !important;
}

```

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/different-representations-of-same-date-column/32155/15 "2024-01-17T16:50:24Z")

</div>