All:

Does anyone know how to calculate the lenght of time between two date in the exact number of years, months and days? I have written a Sub that breaks length of service time into days from an employee's hire date until Now. I then went through normal division,
multiplication and Mod logic to break it into Years, Months and Days based on a 365-day year and 30-day months. However, over a long period of time you lose or gain days because not every year is 365 days and not every month is 30 days. Perhaps I'm over explaining this but you see what I mean. Has anyone else had this experience?
Has anyone written or encountered a solution? Am I possibly missing or misinterpreting a .Net built-in function that is already out there? I'm using ASP.Net 1.1 and visual Studio 2003. Your help would be greatly appreciated.
Demivolt

I know how to get the exact amount of *days* between 2 dates using DateDiff in SQL, but that really doesn't help you. (You can also do the same thing with a timespan but this gives you days as well, not years)

These articles might help you:
http://www.codeguru.com/vb/gen/vb_mi...cle.php/c6779/
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=183
http://articles.techrepublic.com.com...1-5760752.html

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Hi

You can use the System.TimeSpan class to acheive this. Just try this out, this should work for you:

            DateTime dt1 = new DateTime();
            dt1 = Convert.ToDateTime( "2006/10/07");

            DateTime dt2 = new DateTime();
            dt2 = Convert.ToDateTime( "2004/07/17");

            TimeSpan tSpan = dt1 - dt2;

            double iYears, iMonths, iDays;

            iYears = Convert.ToDouble(tSpan.TotalDays) / 365;
            iMonths = iYears * 12;
            iDays = Convert.ToDouble(tSpan.TotalDays);

            Response.Write("Years=" + iYears + "-----" + "Months=" + iMonths + "-----" + "Days=" + iDays);

Regards
Mike

Mike,
    Thats brilliant!

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Thanx buddy for the appreciation

Regards
Mike

Mike,
Thanks for posting the code. I should have stated that I am working in visual basic. When I try your code, Visual Studio gives me a syntaxt error prohibiting
subtacting a date from a date. I have dt1 and dt2 dimmed as DateTime and tSpan dimmed as TimeSpan. Any ideas from anyone?
Thanks, Demivolt

Hey Demivolt

Then its more simpler, just check the code below:

Dim dt1 As DateTime = New DateTime
        dt1 = Convert.ToDateTime("2004/10/07")

        Dim dt2 As DateTime = New DateTime
        dt2 = Convert.ToDateTime("2006/07/17")

        Dim iYears As Integer, iMonths As Integer, iDays As Integer

        iYears = DateDiff(DateInterval.Year, dt1, dt2)
        iMonths = DateDiff(DateInterval.Month, dt1, dt2)
        iDays = DateDiff(DateInterval.Day, dt1, dt2)

        Response.Write("Years=" & iYears & "-----" + "Months=" & iMonths & "-----" & "Days=" & iDays)

Regards
Mike