# Format Date **URL:** \ **Category:** Ask for Help\ **Created:** [June 22, 2024, 11:22am UTC](https://community.glideapps.com/t/format-date/74318 "2024-06-22T11:22:57Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Massimo\_Ridella](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/massimo_ridella/32/62138_2.png) [@Massimo\_Ridella](https://community.glideapps.com/u/Massimo_Ridella)\ **Post date:** [June 22, 2024, 11:22am UTC](https://community.glideapps.com/t/format-date/74318/1 "2024-06-22T11:22:57Z")
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: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16772d80d493a0994b046ab60fccb00517ab199d.jpeg) 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! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [June 22, 2024, 12:20pm UTC](https://community.glideapps.com/t/format-date/74318/2 "2024-06-22T12:20:10Z")
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. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 15, 2024, 9:24am UTC](https://community.glideapps.com/t/format-date/74318/3 "2024-07-15T09:24:22Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.