How can I group dates for a bar chart?

[#1]

How can I group dates (current format DD.MM.YYY) for a bar chart by month and year? I tried: Month(Date#([Closure Due Date],'DD.MM.YYYY')), but this puts all month across years together.

[sunny_talwar · Accepted solution]

What if you do this:

MonthName(Date#([Closure Due Date],'DD.MM.YYYY'))

[martinpohl]

use monthname instead of month so you will get mar 2016, feb 2016, dec 2015 and so on