thanks guys, Dave help me figure it out. it looks like i just over complicated things.
the code below help me sort the most recent date time to the top.
(From row In status_log_dt Order By DateTime.Parse(row.Item(“date time1”).ToString) descending Select row).CopyToDataTable
the code i was using initially was from another thread, and i notice most solutions suggested using datetime.parseexact with “dd/mm/yyyy” format. i’ve tried several other formats as well, none had worked…
it looks like datetime.parse does not require me to specify the format, so it would do just fine for my needs.
do any of you see any potential future problems from using parse instead of parseexact?