I'm using reporting studio (birt) to build a infor BDB dataset.
How can I group by month or even year ?
I can't see how to extract the mentioned date part from the datetime or date types using the available syntax.

Any help would be welcome.
Tank you in advance.

U can break the date in date ,mnth and year seperatly . then using a string concatenate only date n mnth . use that string for grouping

U can break the date in date ,mnth and year seperatly . then using a string concatenate only date n mnth . use that string for grouping

But how can you break the date ? I can't seem to find the way with the available syntax.
I have found several workarounds, as you can manage grouping inside your datasets in BIRT, but in many cases it would be better to have this grouping inside the query.
Tank you.