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
Try with MMM
Just write row(“Date”).tostring
Share screenshot of Datatable in locals