Get Min time and Max time from datatable date in C#

Question

I Have a datatable in which itwo column Datetime and userid. I have to get maxtime and min thime with where condition date and userid in C# I am using this query DateTime OutDateTime = Convert.ToDateTime(record.Compute("MAX(DateTime)", "UserId='" + enrNo + "' and Tdate='" + DateTimee + "'")); DateTime InDateTime = Convert.ToDateTime(record.Compute("MIN(Tdate)", "UserId='" + enrNo + "' and Tdate='" + DateTimee + "'")); Please help me

Mageshwaran R · Answer

Hi Apurva, please try this code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; namespace Date { class Program { static void Main( string [] args) { DataTable dt = new DataTable(); dt.Columns.Add( new DataColumn( "LastDate" , typeof (DateTime))); dt.Columns.Add( new DataColumn( "Cash" , typeof ( int ))); DataRow dr = dt.NewRow(); dr[ "LastDate" ] = new DateTime(2012,10,12); dr[ "Cash" ] = 100; dt.Rows.Add(dr); dr = dt.NewRow(); dr[ "LastDate" ] = new DateTime(2013, 10, 24); dr[ "Cash" ] = 1000; dt.Rows.Add(dr); dr = dt.NewRow(); dr[ "LastDate" ] = new DateTime(2013, 11, 23); dr[ "Cash" ] = 1200; dt.Rows.Add(dr); //Method 1 using dataview DataView dv = dt.DefaultView; dv.RowFilter = "PaymentDate=Min(LastDate)" ; Console.WriteLine( string .Format( "The Payment is {0} on {1}" , dv[0][1], dv[0][0])); // Method 2 using Linq DateTime drLatesPayment = (DateTime)dt.Rows.OfType ().Min( r => r[ "LastDate" ]); Console.WriteLine( string .Format( "The Payment is on {0}" , LastDate)); Console.Read(); } } }

Sachin Singh · Answer

@Amit Gupta sir and @Apurva Singh can you please elaborate , what is the question saying? what is meant by max time whitout a list of times? Is it pointing towards the min time a user has spent on a site and max time the same user has spend on that site on a specific day or what? otherwise below code will give you max time of a date (09/10/2020 23:59:59) YourDateTime.AddDays(1).Date.AddSeconds(-1) and this will give the min time of that day (09/10/2020 00:00:00) myDateTime.Date

Jignesh Kumar · Answer

Hi, Please use this, You can create extention method for datetime so you can use across all paces https://forums.asp.net/t/1519839.aspx?How+to+append+Minimum+Time+and+Maximum+Time+to+a+DateTime+Variable+in+c+

Amit Gupta · Answer

That way you are fetching min and max based on userid and date seems good. What's the issue. Just make sure while filtering with date time, use yyyy/MM/dd format