Does anyone know if this is possible?

I have a listbox which is populated from database which contains valid dates. The date is in a string format d-mmm-yy (e.g. 6-MAY-04). If the listbox is sorted, then these sort with all the 1's then, go up - sort numerically not by date.....if no sorted then they appear in whatever order they are in DB - which also isn't date order due to nature of DB.

Does anyone know of a way to have the listbox sorted by date?

hi there..

i dont know if that is posible, but wouldn be easier to just sort the recordset that fill the combo???

HTH

Gonzalo

hi,

I think Gonzalo is right. You can sort the data in ur recordset and then populate the values in List box.

Thanks,


Lalit
Life Means More...;)