date grouping

[Cirsten Werndly]

When grouping by date it will group by the day, eg
1 September 2011
2 September 2011

Is it possible to reduce this by selecting to group by months or just by years rather than down to individual days?

[Mario !]

Try to add calculated field that represents date by month. Then sort by that field.

[Jerzy Pieńkowski]

How to create calculated field that represents date by month?

[Eugene Kartoyev]

To extract the month name, if your date is shown as it is in my database, i.e.
1 February 2016
29 February 2016

then you can use the following formula in reference to a field called "time"

trim(substring(formatDate(#{time}),indexOf(formatDate(#{time}),' ',0),indexOf(formatDate(#{time}),' ',3)))

[Mr Mukura]

Eugene, thanks for this example, it works well AND has given me a hint on how to use trim and indexof better