Ron,

You have to do convert first the date into character...

substr(dtoc(date),5,2)+substr(dtoc(date),3,2)+substr(dtoc(date),1,2) to x descending

this will be ok now.

Rgds,

Ed