I have a csv file which has the date column. The column is in General format. And the date format is in MM/DD/YYYY with some time. Ex. 10/25/2019 11:21:00 AM. I want to delete the records which are older than last 2.5 months.
First i am finding the fromDate. FromDate = DateTime.Now.AddDays(-76).
Then I am filtering the data table with Assign activity.
dt_irc1 = dt_irc1.Select(“Requested >”+"’"+fromDate.ToString+"’").CopyToDataTable
Requested is the column name. But its giving wrong output. Its also fetching older data than last 76 days.