Date array and Sorting

I think I read that as you want dates sored in an order something like this:  future dates at the top, sorted in ascending order (most imminent first to farthest future last), then past dates at the bottom in ascending order (oldest first to most recent past last).

The easiest way would be to either do this when you query the database (in your CDE_Dates2) or do a query-of-query on CDE_Dates2.  You can do it using a union and adding an extra column for sorting.  Here's some SQL pseudo-code:

SELECT dateColumn, otherColumn, anotherColumn, 0 AS sortOverride

FROM someTable

WHERE dateColumn > <cfqueryparam value="#Now()#" cfsqltype="cf_sql_date">

UNION

SELECT dateColumn, otherColumn, anotherColumn, 1 AS sortOverride

FROM someTable

WHERE dateColumn <= <cfqueryparam value="#Now()#" cfsqltype="cf_sql_date">

ORDER BY sortOverride, dateColumn

This will force the future dates to the top and put past dates at the bottom.

You could do the same thing in a QofQ.

-Carl V.