Hi All,
I Have a columnname with datecolumn , I have to filter with the date or index and update its row values on that date column.
I have used the below query and getting the error.
dt.Select(“3/31/2021=‘New’”).ToList().ForEach(Sub(row) row(“3/31/2021”)=“0.00”)
Getting the Error like this 3/31/2021 is not a vaild date format.
please find the sample excel file.
Filter.xlsx (5.4 MB)
Thanks in advance,
surya