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


DateFilter.zip (10.5 KB)

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

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
DateFilter.zip (10.5 KB)

Try with MMM


Tried, Still throwing the same error

Just write row(“Date”).tostring

Share screenshot of Datatable in locals