Compare only Date of Datetime

Question

hi I have a case when i want to compare only date of datetime object. how can i achieve it without converting it to string.

public bool CheckSendEmailWithinCalendarDay(UnifiedUser user, string messageId, DateTime whenSent)
        {
            var result = _ctx.UserSpecificMessageHistories
                .Where(u => u.UserId == user.User.UserId)
                .Where(d => d.WhenSent.Date == whenSent.Date)
                .FirstOrDefault(m => m.EmailTemplate.Id == messageId);

            return Convert.ToBoolean(result);
        }

You are comparing only Date here: d.WhenSent.Date == whenSent.Date isn't it working ok? — Kamil Budziewski
"it is not workin(g)" - are you getting any error messages? If so, what do they say? — Damien_The_Unbeliever

Raphaël Althaus Raphaël Althaus · Accepted Answer · 2014-04-11T10:50:22

You can use

EntityFunctions.TruncateTime

or, if you're up to date (EF 6)

DbFunctions.TruncateTime

As you seem to be in linq to entities.

Compare only Date of Datetime

1 Answers