
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change date format to month and year from a date
I have a date column say - 'date_column' consists of date like - 02/19/2022 and I just want to show X axis to be like - Feb 2022, I can extract month like - Month(date_column) but how to show year as well as month. Please help to get my desired result.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
MonthName(date_column) should do the trick.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi for bar chart its working, but I have a combo chart and its not working there, it displays dates as it is, please help


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
MonthName() always takes a date and churns out a month and year (with the underlying value of the first of that month). This isn't related to the chart type...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sir just thought to share this information -
1 - when I am using MonthName then only bar chart works properly, but combo (line chart) is not working
2 - when I am using Month(date_column) &' '& Year(date_column) then this works perfect for both the cases, but only in combo chart the sorting order gets changes
I just wanted to know what the reason behind this, just for learning purpose
