Read the data as per the date and write that data in output

[rohith.prabhu]

Hi @Aregala_Yedukondalu ,

Try the below expression & let me know if it helps.
Input_DT.AsEnumerable.Where(Function(x) CDate(x(“date”).ToString(“dd-MM-yyyy”).Equals(Now.ToString(“dd-MM-yyyy”)).CopyToDataTable()

You can reref the below post for more details on the same.

How to get the older dates than the current month

Hi @Marian_B , Could you Check the below Expression : Input_DT.AsEnumerable.Where(Function(x)CDate(x("Date").ToString).Month<Now.Month).ToArray Also you would need to follow the below Post to handle the Errors when you convert directly the Filtered Datarows into Datatable. There might be additional conditions that need to be added if there are multiple date formats/Empty values or change the CDate() to DateTime.ParseExact() to get the appropriate results. Let us know if the expression does…

Thanks,
Rohith