Problem with comparing DateTime

[jaspernorth]

Hi All!

I have DateTimePicker on the form where user selects expiry date for a task. Task and Expiry date is added to DataTable and displayed in DataGridView.
When I try to search for the tasks that end in i.e one day time I get an error:
"Syntax error: Missing operand after 'date' operator."
I am trying to do something like this:

DateTime day1 = DateTime.Now.AddDays(1);
            string format = "dd/MM/yyyy HH:mm"; 
            day1.ToString(format);

            DataRow[] expiryRows = table.Select("Expiry date == day1");
            foreach (DataRow row in expiryRows)
            {
                   MessageBox.Show("task ends in one day");  
            }

I am new to programming, any help would be appreciated.

Thanks!