So I want to view the purchases made in each year, grouped by each year, I have the query set up, but the longtodate(po.ORDERDATE) displays the information grouped to the specific day, is there any way I can convert it to Year. For example, and this doesn't work, but you get the idea: YEAR(longtodate(po.ORDERDATE)). It's on a MYSQL server, but we'll be transferring to MSSQL in the next week, so if you can do both, please do, otherwise, just MSSQL. Thank you.