Filter column in a Datatable using date

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

Hello,

I have a problem to filter a data table using a sequence of filters. I have a data table from Excel, I need to filter “Echéance” by date equal to September.

is filter datatable sequence solve all my problem? or other sequence/code?

Thankyou

[Srini84 (Srinivas)]

@Ahmed_BEN_JEMIA1

Welcome to the forums

Can you check below thread for your reference

Filter Datatable contains datetime

Hi, I have an excel sheet where Robot Start Date column is in General format. Its supposed to contains values in datetime format MM/dd/yyyy HH:mm:ss I would like to filter the datatable to create a second datatable for rows which have the same date MM/dd/yyyy I’ve tried Dt.Select(“[Robot Start Date] LIKE ‘%MM/dd/yyyy%’”).copytodatatable and it says cannot perform operand LIKE on system.string and system.datetime I cannot use filter datatable activity because it is not a table in the Excel sh…

Hope this may help you

Thanks

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

No, that’s not really what I’m looking for .

[postwick (Paul)]

You’d have to create a new column “Month” then For Each through the datatable and Assign Month based on the value in Echeance. Then you can use Filter Datatable to filter on the Month column.

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

Thanks for your feedback. How do I assign the month based on the value in Echeance?

[athira.somasekharan]

Hello,

Will it always come in this format- dd/MM ?
If yes, in filter datatable can you try to give the condition as if column contains “/11”?

Thanks!
Athira

[postwick (Paul)]

Datetime.Parse(CurrentRow(“Echeance”).ToString + “/2022”).Month.ToString

That’ll give you the month as a digit in string format. This assumes the month is the first two digits, so 01/02 would be January 2.

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

I tried with this but I got an error: “Assign: The string was not recognized as a valid DateTime.”
I added a Month column and a Month variable of type string.

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

Hello @athira.somasekharan

yes thank you very much!! it works with this method

[athira.somasekharan]

Glad to help!

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

@athira.somasekharan A little clarification, I’m looking for a function that returns the current month and I add +4 following months.
For example, this month May so it returns September.

[athira.somasekharan]

Hello,

In that case, assign this in a variable:
str_Month=DateTime.Now.AddMonths(4).ToString(“MM”)

And in if condition condition use this: if column contains “/”+ str_Month

Hope this helps!

[Ahmed_BEN_JEMIA1 (Ahmed BEN JEMIA)]

Hello @athira.somasekharan ,
It works when I add this function in the filter :
Datetime.Now.AddMonths(4).Tostring(“/MM”)

[postwick (Paul)]

What value was it trying to parse when you got that error? Are your dates MM/DD?