Unable to filter datatable using date filter

[Palaniyappan (Palaniyappan P)]

No worries
Use this expression in the assign activity

Yourdatatablename = yourdatatablename.Select(“[Domain Expiry Date] >= ‘ # + yourvalue + # ‘ or [VPN Expiry Date] >= ‘ # + yourvalue + # ‘ “ ).CopyToDatatable()

For more info on this

Filter Datatable contains datetime

The syntax is a bit different from what you used: Select("date >= #" + from_date + "# AND date <= #" + to_date + "#") (source) Please check this for reference: FilterDateTimeInDataTable.zip (9.2 KB)

Cheers @Parikshith_V