You could perform a customization to the list_chg.htmpl form to add a list column for the Open Date. For example in the code find:
<PDM_MACRO name=lsCol hdr="Status" attr=status>
<PDM_MACRO name=lsCol hdr="Assigned To" attr=assignee>
Modifiy to look like:
<PDM_MACRO name=lsCol hdr="Status" attr=status>
<PDM_MACRO name=lsCol hdr="Opened" attr=open_date>
<PDM_MACRO name=lsCol hdr="Assigned To" attr=assignee>
(You can change the wording of "Opened" to whatever suits your needs)
Once published a user would be able to sort the order based on Open Date.
Based on the question you asked I'd assume that there are times when a ticket comes into a queue that may be different than the open date. That would be a bit more complicated, because there isn't a field, out of the box at least, that logs the time when a ticket comes into a particular queue. The activity log would log when the transfer occurred, but you wouldn't likely be able to do an additional search argument based on an external table's information. It may be possible to accomplish this scenario, but I'm not sure what would be involved.