How to create a query to GROUP BY Date? Where is GROUP BY?

[StevenM]

HI,

I am trying to return the sum of a set numbers grouped by Month and year in a date.

For example:

number | Date
2 | 01/02/2016
3 | 02/02/2016
5 | 12/03/2016
6 | 21/03/2016
7 | 22/03/2016
8 | 28/02/2017
9 | 29/03/2017
12 | 30/03/2017

The result based on Group By dates month and year would be:
5, 18, 8, 21

I can not see how you do a Group By so need help determining how I do something like this.

Thanks in Advance!

[StevenM]

There must be a day to group a result by date? What am I missing, the lack of documentation makes this frustrating!

[nicolas_dap]

no there is not right now this grouping feature as far as I knwo

[netwayerbusiness1]

Hi there? were you able to solve this issue?

[hattenbachlars]

Hey, also got the same issue, were you able to solve it?

[bonjour_17]