Date format Asp.Net - LINQ Entity Framework

Question

.Where(x => x.POD_DATE == xDATEx)

I need to check if xDATEx is the same date as x.POD_DATE but xDATEx gives me results like 2011-07-17 00:00:00.000 and the x.POD_DATE gives 2011-07-17 01:15:43.577

How do I compare them, despite the results not being in a date only format?

Jakub Konecki · Accepted Answer · 2011-11-18 09:30:12Z

2

http://msdn.microsoft.com/en-us/library/dd395596.aspx

using System.Data.Objects;

.Where(x => EntityFunctions.TruncateTime(x.POD_DATE) == EntityFunctions.TruncateTime(xDATEx))

edited Nov 18, 2011 at 9:30

answered Nov 17, 2011 at 19:18

Jakub Konecki

46.1k8 gold badges92 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user1021182 Over a year ago

Error 2 The name 'EntityFunctions' does not exist in the current context

user1021182 Over a year ago

do you know any other way? i cannot fix it

Dylan Hayes Over a year ago

you need to have the using directive for it at the top of your code file. Using System.Data.Objects;

user1021182 Over a year ago

dylan, can you please explain more i do not understand you answer:( how can i set a day after and do this: Where(x=>x.POD_DATE>=xDATEx && x.POD_DATE<=y1DAYAFTERy); ?

user1021182 Over a year ago

jakub, Error 2 The type or namespace name 'Objects' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)

|

Adi Lester · Accepted Answer · 2012-07-30 22:19:42Z

0

var xDate2 = xDATEx.AddDays(1);
var q = new OrderDataRepository()
               .GetAllOrderData()
               .Where(x => x.POD_DATE >= xDATEx && x.POD_DATE < xDate2)

edited Jul 30, 2012 at 22:19

Adi Lester

25.4k13 gold badges100 silver badges114 bronze badges

answered Nov 18, 2011 at 13:23

user1021182

1612 silver badges12 bronze badges

Collectives™ on Stack Overflow

Date format Asp.Net - LINQ Entity Framework

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related