I have a report where I am exporting the Posting Date but want to export it in a MM/YYYY format. I do not mean just changing to format in Excel which is easy.
From the Item Analysis table I an exporting the Posting Date, Location Code, Sales Amount (Actual). but want to group this by month/year not day.
Can anyone help with this please.