Although DataTables doesn't have row grouping built-in (picking one of the many methods available would overly limit the DataTables core), it is most certainly possible to give the look and feel of row grouping. By the same pattern you can select and group by MONTH(sales_date) to get calculations per each month. See the next section for a more detailed chart. There is a non-free “premium” edition however. I have a date range which I like to group by months, but not from the 1st to last date of the calendar month but by given start date. Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share … How can I get the month from the Birthday Datetime field.I can get it from my today variable. Script by -->