Comparing Dates

[JosephNehl]

Here is one option,

You could enter the date at the end of the data table each time and sort the table by date. I’m not sure if this would be faster or slower than sorting through the table manually however. Try examining this link and see if sorting the data table for each entry, or even at the end of the workflow, could solve your issue.

How to sort a data table based on a column which is a date

Thankyou somuch. I have created the below statement for Sorting based on Datetime. This is not working : (From row In filteredSchemaDT.Select Order By DateTime.ParseExact(row(“RECEIPTDATE”), “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) Descending Select row).ToArray.CopyToDatatable()