Grouping by month in x++

Hi,

Is there possibile to group by month in x++ code.

For example I would like to select all transactions from LedgerTrans and group then by Month(LedgerTrans.TransDate) like in SQL GROUP BY Month(SomeDate)something like that.

Thank you for your help.

I’m also looking for grouping the transactions by month, if you got solution for your qn, can you please help me !!

You don’t even know whether he was using the same version of AX and reporting framework (those five years ago), therefore his answer my be useless in your case. Rather create a new thread, describe your scenario and attach appropriate tags (such as your version of AX)