i would like to sort my data table. the data is populated from the attached excel file.
Status.xlsx (8.6 KB)
i’ve tried using the regular sort activity, but that does not sort properly.
so i try the following:
(From row In status_log_dt Order By DateTime.ParseExact(row.Item(“date time1”).ToString, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable
the sequence fail at assign activity with the code above, then a error saying that the format is invalid.