Data table grouped by month

[ukdub]

It would be great to list data grouped by Month. Is this on the features watch list?

I am trying to create a MYSQL View to achieve a list of net totals grouped by month, this is my best guess so far.

============================

SELECT YEAR(`document_date`), MONTHNAME(`document_date`),
SUM(total_net), SUM(total_gross)
FROM jos_nbill_document

GROUP BY YEAR(`document_date`), MONTH(`document_date`)

============================

[ukdub]

... but the date format seems to be incompatible with these queries

[netshine]

Dates in nBill are stored as Unix Timestamps, so to use MySQL date functions you have to convert them into MySQL dates using the FROM_UNIXTIME function.