Hi

I have a problem to search between two dates, if I use Convert(varchar(10),ContactCreateDate,105) in a single textbow and for a single search date it is okay, but when I use the Convert(varchar(10),ContactCreateDate,105) against two textboxes it did't function.

Can anybody help me ?

MY code

strWhere += " AND Convert(varchar(10),ContactCreateDate,105) BETWEEN '%" + TBContactSearchDateStart.Text + "%' AND '%" + TBContactSearchDateEnd.Text + "%'";

I would highly recommend using a parameterized query, but for the sake of correcting your example, see the code below. You do not need to convert your source column to a varchar for the comparison to work - SQL Server will convert the date strings to datetime

// Declare date variables
DateTime startDate, endDate;

// Try parsing each date (avoids exceptions)
DateTime.TryParse(
    TBContactSearchDateStart.Text, 
    System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat, 
    Globalization.DateTimeStyles.None, 
    out startDate);
DateTime.TryParse(
    TBContactSearchDateEnd.Text, 
    System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat, 
    Globalization.DateTimeStyles.None, 
    out endDate);

if (startDate > DateTime.MinValue && endDate > DateTime.MinValue)
{
    // Save query time by NOT converting the source column
    strWhere += "AND ContactCreateDate BETWEEN '" +
        startDate.ToShortDateString() + "' AND '" +
        endDate.ToShortDateString() + "'";
}