How to extract previous Month date value from Excel

Hi @manjusree_R_N_manju ,

Could you maybe try using the below Expression in an Assign activity instead of Filter Datatable and check if it works :

DT1  = DT.AsEnumerable.Where(Function(x)Not String.IsNullOrWhitespace(x("Month").ToString) andAlso CDate(x("Month").ToString).Month = Now.Month).CopyToDatatable

Here, Month is assumed to be the column name in Excel sheet that is to be filtered.

Direct use of CopyToDatatable could give out Exception if there are no rows found after Filtering. Hence, to handle this case, we could implement the below method :

If there are any other errors shown, Do provide more info on that error, if possible with screenshots so we could help you further.