Filter today date

I want to filter todays date and remove them in datatable aswhere the format is d/M/yyyy from excel =Today() e.g 7/2/2023. How do i do it?

assign the below to your datatable variable

dt.asenumerable.where(function(x) x.not Field(of DateTime)("ColumnName") = Today()).CopyToDatatable

@jack.chan this is for studiox

1 Like

HI @Mark_Rajkumar

You can use Assign activity

DT_Output = DT_Input.AsEnumerable.Where(Function(r) DateTime.Parse(r("Column Name").ToString)=New DateTime(Now.Year,Now.Month,Now.Day).ToString("d/M/yyyy")).CopyToDataTable



If your data is recognized as Date Time type in your worksheet, the following works.


note : please input Today in advanced editor.

If your data is recognized as text in your worksheet, the following will work.


note : please input the above expression in advanced editor.


1 Like

HI @Gokul001 can u give me a detailed step to understand further

@Anil_G can u assist me

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