Filter today date

[Mark_Rajkumar (Mar)]

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?

[jack.chan]

assign the below to your datatable variable

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

[Mark_Rajkumar (Mar)]

@jack.chan this is for studiox

[Gokul001 (Gokul Balaji)]

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

Regards
Gokul

[Yoichi]

Hi,

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.

Regards,

[Mark_Rajkumar (Mar)]

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

[Mark_Rajkumar (Mar)]

@Anil_G can u assist me