Find TotalDays between two Datetime? variables

Question

   DateTime? arrival = (DateTime?)(t.ArrivalDate.Value);
   DateTime? departure = (DateTime?)(t.DepartureDate);

Okay i know both of them are nullable and .TotalDays does not work on nullable object. So kindly tell me how am i supposed to find days difference between these two objects.

Note: Both objects contains Date(s) i.e. are not null

This is DateDiff https://msdn.microsoft.com/en-us/library/ms127413%28v=vs.110%29.aspx — Mahesh, Feb 09 '15 at 05:24

Avner Shahar-Kashtan · Accepted Answer · 2015-02-09T05:32:38.077

4

Since there's no meaningful value to their difference if any of them is null, you only need to concern yourself with the case where they're not:

DateTime? arrival = (DateTime?)(t.ArrivalDate.Value);
DateTime? departure = (DateTime?)(t.DepartureDate);
double? totalDays = arrival.HasValue && departure.HasValue 
   ? (double?)(departure - arrival).GetValueOrDefault().TotalDays
   : null;

The subtraction should work because of implicit casting to DateTime.

edited Feb 09 '15 at 05:32

answered Feb 09 '15 at 05:25

Avner Shahar-Kashtan

14,492
3
37
63

not Working. Kindly run this in your own debugger then paste here :) – Waqar Ahmed Feb 09 '15 at 05:27
Fixed. The essence was right, I just needed to tweak the syntax. :) – Avner Shahar-Kashtan Feb 09 '15 at 05:29
DateTime? departure = DateTime.Now.AddDays(2.5); why did u add 2.5?? – Waqar Ahmed Feb 09 '15 at 05:30
No reason. Just needed a number there. – Avner Shahar-Kashtan Feb 09 '15 at 05:32

Adil · Answer 2 · 2015-02-09T05:30:38.563

1

Note: Both objects contains Date(s) i.e. are not null

If you are sure that dates never have null then you can use .Value for nullable DateTime objects. You will get exception when any of them is null.

double days = departure.Value.Subtract(arrival.Value).TotalDays;

edited Feb 09 '15 at 05:30

answered Feb 09 '15 at 05:25

Adil

146,340
25
209
204

score 0 · Answer 3 · answered Feb 09 '15 at 06:16

    //Set dates
    DateTime? beginDate = DateTime.Now;
    DateTime? endDate = DateTime.Now.AddDays(10);

    //Check both values have a value (they will based on above)
    //If they do get the ticks between them
    long diff = 0;
    if (beginDate.HasValue && endDate.HasValue)
        diff = endDate.Value.Ticks - beginDate.Value.Ticks;

    //Get difference in ticks as a time span to get days between.
    int daysDifference =  new TimeSpan(diff).Days;

score 0 · Answer 4 · answered Feb 09 '15 at 06:56

Here i give you tested code please have a look :

 DateTime? startDate = DateTime.Now;
        DateTime? endDate = DateTime.Now.AddDays(5);


        long differenceOfDays = 0;
        if (startDate.HasValue && endDate.HasValue)
            differenceOfDays = endDate.Value.Ticks - startDate.Value.Ticks;

        int daysDifference = new TimeSpan(differenceOfDays).Days;

Find TotalDays between two Datetime? variables

4 Answers4