How to get count of days between two dates in linq C# select new query

Question

0.00/5 (No votes)

See more:

I am trying to get a count of number of days between two days inside Linq Select new query but I am getting an output like this -00:03:42.2470000.

Below is my code. Any help will be appreciated.

What I have tried:

<pre>
              var dayInProcs = DateTime.Today;
			  var exportToexcel = data.admin.AsQueryable()
                .Include(x => x.employees.contractors)                 
                .Include(x => x.employees.contractorRoles) 
                .Where(x => x.employees.contractors.Id == 60);
				
				var roles = exportToexcel.Select x => new
				{
				delivered = x.ArrivalDate - x.SortedDate, // I want to get 20 here
                DaysInProcess = x.ArrivalDate - dayInProcs // And 5 here
               }).Distinct()),

Posted 7-Nov-19 8:33am

Member 1283347

Updated 7-Nov-19 8:44am

Add a Solution

1 solution

Add a Solution

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

Maciej Los · Answer 1 · 2019-11-07T08:44:00

Solution 1

Take a look at code below:

C#

DateTime ArrivalDate = new DateTime(2019,11,7);
DateTime SortedDate = new DateTime(2019,10,18);

int daysDiff = (ArrivalDate - SortedDate).Days;
//returns 20 ;)

For further details, please see: TimeSpan Struct (System) | Microsoft Docs[^]

Posted 7-Nov-19 8:44am

Maciej Los

Comments

Afzaal Ahmad Zeeshan 7-Nov-19 18:32pm

5ed!

Maciej Los 8-Nov-19 2:08am

Thank you.

Member 1283347 8-Nov-19 8:28am

Hi Thanks for your solution but this does not work in Entity Frame work. I have solved it be using DbFunctions.DiffDays

How to get count of days between two dates in linq C# select new query

1 solution

Solution 1

Add your solution here

Preview 0

How to get count of days between two dates in linq C# select new query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us