Format Date

[Massimo_Ridella]

Hello everyone! Glide Noob here

I have a column which holds dates in this format:
2023-12, 2024-01, 2024-02, 2024-03, 2024-04, 2024-05

Here is a screenshot:

I would like a column that changes the dates to look like this:
‘2023-12’, ‘2024-01’, ‘2024-02’, ‘2024-03’, ‘2024-04’, ‘2024-05’

I would need this formate since i’m constructing a graph with quickchart.
Thank you in advance!

[Darren_Murphy]

It looks like your list of dates is the result of a joined list?

Assuming that’s true, what you should do is first use a template column to add the single quotes to the source dates, and then take a joined list of the template column.