How to filter the date column with current month & get the datarow count of filtered current month. Attached the Excel File & sample xaml (10.5 KB)

Hey, you can use.
read range
for eachrow activity
DateTimeVariable = Datetime.Parse(datevariable)
You can then use DateTimeVariable.ToString(“MM”)

DT.Asenumerable.Where(Function(r) Datetime.ParseExact(r(“Date”).Tostring,“dd-MM-yyyy”,Nothing).Month=Now.Month).Count

Here its throwing an error @Gangadhar_Athili (10.5 KB)

Try with MMM

Tried, Still throwing the same error

Just write row(“Date”).tostring

Share screenshot of Datatable in locals