Filter dynamic value based on current month from an Excel datatable

I have variable values on Excel (ex: 001,002,003,004,005,006,007,008,009,010,011,012). Based on the current month, I need to filter a datatable and delete all the rows with current month.

Can anyone help me?
Many thanks,

You can use Filter Datatable

Date.Now.ToString(“MM”) this will return month in integer as ‘08’
Date.Now.ToString(“MMM”) if you use like this it will return month as ‘Aug’

I did this:

where strCurrentMonth is = Now.ToString(“MM”)
I need the Bot to read “007” as final output if July. “010” if October and so on.
Thank you!

I have tried both solutions, yours and mine, none of them are working. Do you know why?

Try adding here
strCurrentMonth is = “0”+Now.ToString(“MM”)
Welcome to the forum.

Maybe you can share some sample data / Excel with us. So we can check more individually your case. Thanks

Thank you!
Here is the datatable to filter:

I want to remove the entire set of rows with current year and current month. The current month comes in this format: "001, 002,004, …, 010,011,012).

Thank you!

Thank you @Sudharsan_AIT! Unfortunately is not working even like that

Just checking is the variable for your year in the format of yyyy?
Also make sure there aren’t any spaces in the column names, that can sometimes be hard to see.

Following flow is doint the filtering:

adopt ColNamesOrIndex and your other VarNames:

(From d In YourDataTableVar.AsEnumerable
Let m = Now.toString(“MM”).PadLeft(3,"0"c)
Let y = Now.ToString(“yyyy”)
Where Not (d(“Fiscal Year”).toString.Trim.Equals(y) And d(“Period”).toString.Trim.Equals(m))
Select d).toList


Similar we can do in Filter Datatable Activity (when excel Values are not having spaces e.g on begin or end)

Try this

Thank you so much

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