Get data from previous dates

[alexis.mendoza.rpa]

I have the following case:

I have a table with 4 columns where column 4 has date data, I require to filter the data table and keep all rows that are > 2000-02-02

How can I do this?

[dls (danielhlsoliveira)]

You can try this:

1 - Add a read range, lets say to dtInput
2 - Add an assign like this:
dtOutput = dtInput.AsEnumerable().Where(Function(row) DateTime.ParseExact(row.Field(Of String)(3), “yyyy-MM-dd”, CultureInfo.InvariantCulture) > DateTime.ParseExact(“2000-02-02”, “yyyy-MM-dd”, CultureInfo.InvariantCulture)).CopyToDataTable()

You should have the filtered rows. (I put “3” on the linq because the index starts at 0, but adjust to the correct one if thats not the case)

[pravallikapaluri]

Hi @alexis.mendoza.rpa

Duplicate Post

Filter data table with dates

I have the following case: I have a table with 4 columns where column 4 has date data, I require to filter the data table and keep all rows that are > 2000-02-02 How can I do this?

Hope it helps!!