Date Difference / Years and Months Elapsed

mmunoz · #1 23-Aug-2008, 20:19

Can anyone guide me as to how to display on a text box the number of years and months that have past between today and the date from a calendar datepicker placed on a form from which the user will select the account opening date. I want display on the text box "This account is x years and x months old".

Here is the code that I am using, but of course is incomplete. Please correct it accordingly. Thanks.

VB / Visual Basic Code:

 Dim Inception As Date = DateTimePicker1.Value
        Dim Today As Date = DateTime.Today
        Dim Span As TimeSpan = Today.Subtract(Inception)

        TextBox2.Text = " This account is " & Span.TotalDays.ToString() & " years old"

erniegerdie · #2 04-Sep-2008, 05:28

Can you not use DateDiff in VB.Net?

DateDiff("yyyy", DateTimePicker1.Value, DateTime.Today) for years

Using "m" for months?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Date Difference / Years and Months Elapsed

Re: Date Difference / Years and Months Elapsed