Filter dates that occur after one date. Filter Table Activity

[samir (Samir Mohite)]

Hi @adorp,

I’ll suggest you to use Assign activity, as shown in below.

Dt = Dt.Select("[DateColumn] >= '#"+initialDate+"#'").CopyToDataTable

here,
Dt —> your datatable variable.
mention date column header instead of DateColumn.
initialDate —> String var. having date should be in MM/dd/yyyy format.

Follow the link below, for your reference.

Filter Datatable using range date x to y

@aliaga If you’re using variable to give input as date then you have to use String var of with MM/dd/yyyy format. As shown in below shot, dt.Select("[Letter Date] >= '#"+date1+"#' AND [Letter Date] <= '#"+date2+"#'").CopyToDataTable e.g [image]