Date-Time format, here's the resource you need!

[Jon_L]

We all know how frustrating it can be when dealing with date and time.

The format date column is useful, but it doesn’t always work the same as other date formats IME. One of the support team messaged me today after the useless AI bot tried to answer my question and told me the format that Glide uses:

The Format Date column uses Luxon formatting. Here’s a helpful resource that I use when I need to format the date using this column in Glide: luxon - Immutable date wrapper

I hope this is useful to others.

Cheers!
`

[ThinhDinh]

I use this as well. They should add this to the column notes for easier access.

Thanks for sharing, and just for a note, the Format Date column might lead to issues on certain operation systems. I had problems with it on iOS in the past.

Relation will recognize a date match but not Query

The Format Date column is the work of satan. It will work perfectly 99.9% of the time, but that 0.1% when it breaks will do your head in. I do not use it, and I do not recommend using it. The Math approach is a little more work, but is 100% reliable. For more about why I don’t recommend the Format Date column, see below: