Different representations of same Date column

[Maxim_KM]

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).

[Manu.n]

I did a YC with this option

Date Conv

Hello, Here is a script (for a special case ) 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/ Y…

[Maxim_KM]

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.

[Maxim_KM]

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

[gvalero]

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

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

Saludos…

[Maxim_KM]

I have following tab:

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?

[kyleheney]

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?

[BlakeWS]

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!

[Maxim_KM]

Okay, ended up with Experimental Code column and simple echo-date function (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:

[Maxim_KM]

It’s inline list with heavy CSS formatting

[Darren_Murphy]

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…

[Maxim_KM]

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

[phong_tran]

how to have interface like this

[Maxim_KM]

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.

<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;
}