Hi.I want to filter the Datatable with date newer than ‘15-01-2018’ using Filter Data table Activity.Can anyone help me
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.
inputDate = Date.ParseExact(“15-01-2018”,“dd-mm-yyyy”,System.Globalization.CultureInfo.InvariantCulture)
resultRows = dt_Test.Select(“CreatedDate > #” +inputDate.ToString +"#")
Thank you so much for the help
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.