Hi,
I have an excel sheet in which I have to filter the datatable on 2 points
If status is ABC Completed.
IF Current day is Monday than filter the Completion dates based on Friday,Saturday,Sunday.
Using the above filtering the datatable can be empty also if both the conditions do not match.
I have attached the excel sheet for the same. Book1.xlsx (1.2 MB)
I have managed to solve for the Filtering of Status, but can anyone suggest on how to filter based on the above 2nd condition.
Assign a data table and paste the below query DT.Select(“[Date Column] >= #”+Dates.ToString +“# AND [Date Column] <= #”+Dates2.ToString+“#”).CopyToDataTable
Where Date Column is the column of your Datatable containing Date
And
Dates and Dates2 are the variables with datatype date time.
Cheers