Hi I have a dt with columns date, order, cost etc date(row wise)- 4/28/2021, 4/28/2021,…5/2/2021…5/14/2021. I need to group this date by week. Like 4/28/2021 to 5/5/2021 will be week1. Next 7 days by week 2 etc

Except of Item counter (we can handle later) we are close on it with following prototype LINQ (From d In dtData Let k=CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(CDate(d.Item("Date")), System.Globalization.CalendarWeekRule.FirstDay, DayOfWeek.Thursday) Group d By k Into grp=Group Let gdo = gr…

Group Dates-By Week

Help Something Else

ppr (Peter Preuss) June 9, 2021, 1:06pm 4

Topic		Replies	Views
Grouping data table and select rows with Max date Community question , community	3	2318	May 9, 2022
Need help reorganizing datatable with Min and Max dates Studio datatable , studio , question , variables_management	4	857	July 1, 2021
Filter DataTable by current week Help	1	1135	April 8, 2019
Split a Month into Weeks with respect to Work Days Studio datatable , studio , datetime	1	953	February 14, 2023
Group By Data Table on Date Range Studio studio , question , find_references	1	1739	May 6, 2021

Group Dates-By Week

Related topics