I can't seem to make an unbound grid deal with dates properly.

Anybody have a sample of how to display dates in a DataViewGrid such that the column that displays dates sorts by date and not by the string representing the date?

I also need to set the date format used.

There is a ValueType property that looks promissing except I have not been able to set/change an unbound column's ValueType. Is that possible? How?

In my case I need to set the column type dynamically based on SQL passed into a procedure so I cannot set the ValueType at design time. Given that can ValueType be changed once rows exist?

(Most of the above assumes, maybe incorectly, the proper way to deal with dates is to use the ValueType property.)

TIA