DAL: How to Sort by Month and Year

I am using DAL and want to order a selection by the month and year, not necessarily by date. DAL only orders things by the full date, not month and year.
The DBMS is the one actually doing the ordering (sorting). The SQL statement can only request ORDER BY against a column name -- not a portion of a column. Your only option is to retrieve the data, parse it yourself for the desired portions, and sort on those in your Macintosh application.
Published Date: Feb 18, 2012