Filter dates that occur after one date. Filter Table Activity


I’m trying to use the Filter Table Activity to filter based on the dates. What I’m looking is to filter all dates that are after any given initial date.

I would like to have this initialDate as variable and then only show the dates that occur after that date.

I appreciate your help :slight_smile:
Thank you!

We can use FILTER DATATABLE ACTIVITY but that column must be the date only then we can filter with a DateTime value
Kindly have a view on this thread

Cheers @adorp

Hi @adorp,

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

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

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.