How to order the data in a table according to dates?

How to order the data in a table according to dates?

Hi,

I have made an events form and a view of this form. When the user enter data with the begin and finish dates, I want the for to be ordered according to begin date putting the nearest event to the top followed by the coming dates. However when the current date is later than the finish date, I want it to be automatically removed. For example today is 08.09.2010 and there is an event beginning on 08.09.2010 and finishing on 10.09.2010. I want it to be at the top due to its begin date. On 11.09.2010 however it shall be removed automatically.

I suppose it is possible to be coded by deluge, but I couldnt do it.

Many thanks in advance,

Vera