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

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]

I did a YC with this option [image] Date Conv Ask for Help 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 di…

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.

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

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] but again, I don’t know if this is what your are looking for. Saludos…

I have following tab: [image] 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…

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?

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]

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: [image] [image]

It’s inline list with heavy CSS formatting :slight_smile:

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

Different representations of same Date column

Ask for Help

Manu.n September 22, 2021, 4:12pm 2

I did a YC with this option

Topic		Replies	Views
Display Date in different formats Ask for Help	5	2261	February 17, 2022
Format a date Ask for Help	2	125	August 7, 2025
In-app filter for only date data Ask for Help	3	39	September 19, 2025
Today and 14 days ahead Ask for Help	23	889	February 10, 2023
Time format in Glide UI Ask for Help	1	345	January 18, 2023

Different representations of same Date column

Related topics