in between date

[basti42]

hello!
i have these data:
date item
08/10/2007 07:34 AM data1
08/10/2007 07:35 AM data2
08/10/2007 07:36 AM data2
08/10/2007 09:01 AM data3

how would i find the data in date between 08/10/2007 07:33 AM to 08/10/2007 07:37 AM?

i try this but it will find all including the 09:01 AM

if (DateTime.Compare(DateTime.Now.AddMinutes(-20),DateTime.Now)<0)

[nmadd]

Unless I'm misunderstanding the question, I'm not sure what that last line has to do with finding the DateTimes in between your start and stop. You could just put your DateTimes in a list and just loop through it and check if each one is between your start and stop DateTimes.

Assuming your have your data in a list called times and you've created a start and stop DateTime.

foreach (DateTime dt in times)
{
    if (dt > startTime && dt < stopTime)
    {
        MessageBox.Show(dt.ToString());
    }
}

[basti42]

if (Convert.ToDateTime(dateValue) > DateTime.Now.AddMinutes(-20) && Convert.ToDateTime(dateValue) < DateTime.Now)
{
//add to the datagrid and
//save to the database
}

tnx you gave me an idea how to solve the problem...

[GaryMazzone]

Are you querying a database for the infor? If so you would use a between construct in the SQL statement (or a > < constraint) in the WHERE cluase.