Hi everyone,

is there any possibility to have the Date column in Glide Table in this format - mm/yyyy ?

Shortest format is now mm/dd/yyyy…

Thank you,

M.V.

Hi everyone,

is there any possibility to have the Date column in Glide Table in this format - mm/yyyy ?

Shortest format is now mm/dd/yyyy…

Thank you,

M.V.

No, not directly - which I find a constant source of annoyance.

If you want a specific date format for display in your app, then you need to construct a string that matches the desired format with a combination of math and template columns. Essentially, you need to deconstruct the date into its year/month/day components, and then piece them back together again.

2 Likes

Can you give me an ideea ? I deconstructed the date with Split Text, now what ?

Split Text won’t help you. As I mentioned, you need to use math and template columns.

Assume your date is in a column called “date”:

- Math column with the formula
`Year(date)`

- this will give you the year - Math column with the formula
`Month(date)`

- this will give you the month number - If you need a leading zero with the month number, then you’ll need an if-then-else column:
- if month number < 10 then 0, else blank

- Then put it together with a template column:
`{pad}{month}/{year}`

, where:- {pad} is the output of the if-then-else column,
- {month} is the output of the second math column, and
- {year} is the output of the first math column

3 Likes

You made my day !

1 Like