How to calculate days difference LINQ

Question

0.00/5 (No votes)

See more:

Hello,

How to calculate the date difference of two dates and get the final difference amount.

I tried using following code:

C#

  var tdays = from items in Vals
                           select new
                           {
                               days = 
                               (
                               DbFunctions.DiffDays(items.maxdate, items.mindate )
                               )
                           };

But I am getting error:
<pre lang="C#">base = {&quot;This function can only be invoked from LINQ to Entities.&quot;}</pre>

Posted 1-Dec-15 10:11am

apr1234

Updated 1-Dec-15 10:12am

v2

Add a Solution

3 solutions

Solution 1

Basically, you can subtract two DateTimes and get a TimeSpan as a result:

C#

DateTime start = new DateTime(2015, 12, 1, 20, 0, 0);
DateTime end = new DateTime(2015, 12, 2, 4, 30, 10);
TimeSpan span = end - start;
int hours = span.Hours; // hours = 8;
int minutes = span.Minutes; // minutes = 30;
int seconds = span.Seconds; // seconds = 10;
int days = span.Days; // days = 0;
double totalDays = span.TotalDays; // totalDays = 0.35428241

You can find find more informations on TimeSpan structure here:
MSDN: TimeSpan Structure[^]

To answer to your question, we would need to know which type your Vals variable is an enumeration of; and if this type is not a common one (i.e., you defined it yourself), we would need to know how its maxdate and mindate members are defined.

Posted 1-Dec-15 10:48am

phil.o

Updated 1-Dec-15 10:58am

v3

Solution 3

Rather do it this way-

C#

DateTime oldDate = new DateTime(2015,11,2);
DateTime newDate = DateTime.Now;
TimeSpan ts = newDate - oldDate;
int differenceInDays = ts.Days;

Console.WriteLine("Total days: {0} ", differenceInDays);

-KR

Posted 1-Dec-15 18:10pm

Krunal Rohit

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

debashishPaul · Accepted Answer · 2015-12-01T13:30:00

Solution 2

Try following:

C#

var days = from items in Vals
            select new
            {
                days = items.maxdate - items.mindate
            };

foreach (var day in days)
{
    Console.WriteLine(day.days.TotalDays);
}

Posted 1-Dec-15 13:30pm

debashishPaul

Updated 1-Dec-15 13:31pm

v2

Comments

apr1234 2-Dec-15 10:44am

Thank you Debashish, it worked!

debashishPaul 2-Dec-15 16:43pm

Happy to help...

How to calculate days difference LINQ

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to calculate days difference LINQ

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us