How to get duration between start and end date

Question

Possible Duplicate:
Converting Days into Human Readable Duration Text
How do I calculate difference in years and months given a start and end

I use (end date - start date).TotalDays it returns total days. For example, 145 days

But I don't want total days.

It is possible to convert 145 days to 3 months and 25 days something like this.

Yeah, I can't figure out about this problem. I don't know how to define months. — aratn0n, Feb 01 '13 at 13:57
@SLaks - I would think you would define it as calendar months, like "the number of month barriers crossed from start date to end date, -1 if start date's day of month > end date's day of month." — mbeckish, Feb 01 '13 at 14:02
A month is approximately `30.46666` days. How do you want your rounding? — H H, Feb 01 '13 at 14:07
If days > 365, do you also want years, like "1 year 2 months 6 days"? — mbeckish, Feb 01 '13 at 14:07

spender · Answer 1 · 2013-02-01T14:30:38.793

4

A bit harder than it initially seems...

I suppose you could do something like this, which has the advantage of counting actual calendar months rather than estimating months to be 30days or similar.

var now = DateTime.Now;
var future = DateTime.Now.AddDays(new Random().NextDouble() * 365);
//dates above for example only

var xx = Enumerable.Range(0,int.MaxValue)
        .Select(i => new{numMonths = i, date = now.AddMonths(i)})
        .TakeWhile(x => x.date < future)
        .Last();
var remainingDays = (future - xx.date).TotalDays;
Console.WriteLine("{0} months and {1} days",xx.numMonths,remainingDays);

edited Feb 01 '13 at 14:30

answered Feb 01 '13 at 14:13

spender

117,338
33
229
351

I just realised that things go wrong if future < now. You get the idea though. – spender Feb 01 '13 at 14:36
+1 for using a LINQ expression instead of a `while` loop :-) – fero Feb 01 '13 at 15:32

score 1 · Answer 2 · answered Feb 01 '13 at 13:58

if you assume a month to be 30 days, this below might help.

var start = DateTime.Today;

var end = DateTime.Today.AddDays(99);

var timeSpan = end.Subtract(start);

var months = (int)timeSpan.TotalDays / 30;

var days = timeSpan.TotalDays % 30;

var str = string.Format("{0} months, {1} days", months, days);

Peter · Answer 3 · 2013-02-01T14:21:22.703

0

To overcome the number of days problem in a month, just look at the years and months

DateTime d1 = New DateTime(2002, 1, 1);
DateTime d2 = New DateTime(2000, 10, 1);
int years = Math.Abs((d1.Year - d2.Year));
int months = ((years  * 12)  + Math.Abs((d1.Month - d2.Month)));

edited Feb 01 '13 at 14:21

answered Feb 01 '13 at 13:57

Peter

27,590
8
64
84

The question is about months/days. This doesn't help... – Cristian Lupascu Feb 01 '13 at 14:04
agree that the timespan does not give you anything on #months – Peter Feb 01 '13 at 14:22

qxn · Answer 4 · 2013-02-01T14:04:03.350

The difference of two DateTime objects results in a TimeSpan object. Since the time spanned by a month is not consistent among months, how would a TimeSpan object be represented by a number of months?

In order to calculate the number of months between two dates, you'd need to know the start date and end date ahead of time so you can calculate the actual number of months (keeping in mind leap years, etc.) between them.

score 0 · Answer 5 · answered Feb 01 '13 at 14:12

If you want years, months, days:

Years = max number of years you can subtract from end date such that the result is still > start date.
Months = max number of months you can subtract from the previous result such that the result is still > start date.
Days = number of days between previous result and start date.

score -3 · Answer 6 · answered Feb 01 '13 at 13:56

-3

Try use the time span to string...

answered Feb 01 '13 at 13:56

Chen Kinnrot

20,609
17
79
141

How to get duration between start and end date

6 Answers6