Is there a way that I can get the smallest date value without SORT and DESC, through SELECT only?
Using Unidata 6.1, I would use:
:SELECT BY <DATE_FIELD>
that would sort the keys by the lowest date value. Then you would have to use the first value in the select list.
I'm not sure if that answers your question.