I have a date column in a database table.

[![enter image description here](https://i.stack.imgur.com/TNsOq.png)](https://i.stack.imgur.com/TNsOq.png)

I'm using a LINQ expression that search records using today's date against this DOB column.

```
DateTime searchDate = DateTime.Now;
Expression<Func<Contact, bool>> cntExpression = p => p.DOB.HasValue && p.DOB == searchDate

```

Now, When I try to execute this expression then no record is returned. The reason is that I am passing 'DateTime' value in LINQ expression and the DOB column in the database table is of 'Date' type. So it's trying to match a datetime value against a date only value.

I already tried to use:

```
DateTime searchDate = DateTime.Now;

```

but it didn't solved the problem.

Please help me in fixing this issue.

Thanks in advance.