Date Comparison – Entity Framework

A quick tip about how to compare a datetime field in our database and to be extact only the Date part ignoring the time.

Let’s say that we want to find all records that where created today:

Where(@"Day(it.CreatedTime) == Day(CurrentDateTime())

AND Month(it.CreatedTime) == Month(CurrentDateTime())

AND Year(it.CreatedTime) == Year(CurrentDateTime())")

We are using the ESQL functions Day,Month,Year and CurrentDateTime.

If there is a better way please let me know.

Enjoy!