How group by date in months

ad admin_wiky 21 Oct, 2014

Hi all,

I have a table with column (date> rrrr-mm-dd) and I need group the results by months like january, febrauary.
any simple way how to do it<

thx.

Gr GreyHead 21 Oct, 2014

Answer

1 Likes

Hi homeopat,

What kind of grouping do you need?

If you need to total by month then this StackOverFlow answer may help.

Bob

ad admin_wiky 22 Oct, 2014

Hi Bob,

but How it use in CC? I tried put to the group field
[list]datum.month[/list]
[list]MONTH(datum)[/list]
but error is occurred

Gr GreyHead 22 Oct, 2014

Hi Homeopat,

This is the ChronoForms forum so it wasn't obvious that you were asking about CC - I'll move the thread over. Not sure that I know the answer though.

Personally if I want to group by month the simplest way would be to add a month column to the table. Though perhaps you can create that on the fly - my MySQL isn't good enough to know how though.

Bob

ad admin_wiky 22 Oct, 2014

Good point, I added the date variable to fields in admin

MONTH(date_variable)

but it doesnt grouping by date😟

thx

Max_admin 23 Oct, 2014

1 Likes

Please try

:MONTH(date_variable)

Regards,
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

This topic is locked and no more replies can be posted.