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

Apurva Singh

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
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 Singh6y ago
@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 Kumar6y ago
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 Gupta6y ago
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