Rows from last 7 days only

[Mohammad_Irfan (Mo Irfan)]

Hi, i am trying to filter a DT where i have a column named as Date where i need to get only the datas from past 7 days.

thanks

[rlgandu]

Hi,

Sequence:
- Assign: filteredDataTable = dataTable.Clone()
- For Each Row: row in dataTable
- If: row(“Date”) >= DateTime.Now.AddDays(-7)
- Add Data Row: row to filteredDataTable
- Use filteredDataTable as needed
Thanks

[Mohammad_Irfan (Mo Irfan)]

It takes a long time
i dont want using for each loop

[rlgandu]

Hi,

Use an Assign activity to create a new DataTable variable to store the filtered results. Let’s call it filteredDataTable

filteredDataTable = yourDataTable.Select(“[Date] >= #” + DateTime.Now.AddDays(-7).ToString(“MM/dd/yyyy”) + “#”).CopyToDataTable()

Thanks

[supermanPunch (Arpan)]

Hi @Mohammad_Irfan ,

Could you check the below Expression :

DT.AsEnumerable.Where(Function(x)CDate(x("Date").ToString).Date>=Now.AddDays(-7).Date).CopyToDatatable

We might receive error on CDate() but it depends on the format or the values the date column will hold. Do check and let us know if it doesn’t work as expected.