How to use filter data table based on some conditions

Help
#1

Hi.I want to filter the Datatable with date newer than ‘15-01-2018’ using Filter Data table Activity.Can anyone help me

#2

Hi Sandhya,

Use the Select() method to filter the date column. Since this date format is different than the regular dd/mm/yyyy we have to use ParseExact method. For user defined date values we use # symbol to enclose the input.

For instance:

inputDate = Date.ParseExact(“15-01-2018”,“dd-mm-yyyy”,System.Globalization.CultureInfo.InvariantCulture)
resultRows = dt_Test.Select(“CreatedDate > #” +inputDate.ToString +"#")

Happy Automating!

#3

Thank you so much for the help

#4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.