Comparing only date part of datetime field with another date

(0) Share

Report

Posted on by Khaled Rimawi

145

Hi ,

I have a datetime field that i want to compare only the date part of it with another date in a LINQ query , but an error is thrown , here is a code snippet :

var currentDate = DateTime.UtcNow.Date;
var contacts = (from c in service.ContactSet
&& c.new_testDate.Value.Date.Equals(currentDate)
select c
).ToList();

the error :

"Invalid 'where' condition. An entity member is invoking an invalid property or method."

is it a LINQ limitation ? and how can we solve it ? Thanks.

I have the same question (0)

All responses (4)

Answers (0)

Khaled Rimawi 145 on at

Like (0)

Report

Edit :

Here is the write code snippet :

var currentDate = DateTime.UtcNow.Date;

var contacts = (from c in service.ContactSet

where c.new_testDate.Value.Date.Equals(currentDate)

select c

).ToList();

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

can you try this please?

where c.new_testDate.Value.Date == currentDate

Was this reply helpful? Yes No
Khaled Rimawi 145 on at

Like (0)

Report

@Erhan Keskin , same error

Was this reply helpful? Yes No
erhan.keskin 2,253 on at

Like (0)

Report

There are solutions here, please have a look and choose the best one for you.

www.codeproject.com/.../LINQ-query-to-compare-only-date-part-of-DateTime

Was this reply helpful? Yes No