hello

is there a way to query the database and produce a list based on the query?

ie:

using CB lists, create a list based on the query

SELECT DATEDIFF('[cb_date1]',now())

where cb_date1 is a future date and the query shows on the website ho w many days to the date.

what i am after is to list all users, ranking them from least amount of days ( from the query ) to most.

the problem is that the CB list manager only allows fields to be used and not queries ( that i can figure out )

i was thinking there must be a way to substitute the query into a field, but am concerned that it will not be updated to the time the list is generated.

thanks