Mel, just ORDER BY MyTable.HiredDate would order in correct chronological order Year-Month-Day. Or have I misunderstood the question? If you want to exclude the year from the HiredDate to get all month/day records together then you could use the following as a possible solution:

SELECT Fld1, Fld2, FldX, SUBSTR( DTOS( MyTable.HiredDate ), 5 ) AS MnthDay FROM MyTable ORDER BY MnthDay

Another option could be:

SELECT Fld1, Fld2, FldX, MONTH( HiredDate ) AS nMonth, DAY( HiredDate ) AS nDAY FROM MyTable ORDER BY nMonth, nDay


>In building a Select-SQL statement, I need the Order By to actaully be ordered by the Month and then Day of a date field similar to:
>

>Order By MONTH(MyTable.HiredDate), DAY(MyTable.HiredDate)
>

>Anyone know how to do something like this?
>
>I would prefer not to have to create a temp index to do this.
>
>Thanks,
>Mel Cummings