One of the problems with datediff function is that even if the two dates are 31-12-2011 and 01-01-2012,it will show the difference as 1 year.How to overcome this problem????

SO how do u want to display the date difference??? in months, year or days??? whatever parameter u will give in the date diff function it will be dependent on that....

No, Icannot be, or you did it wrong. Check this example:

Dim d1 As New DateTime(2011, 12, 31)
Dim d2 As New DateTime(2012, 1, 1)
Dim ts As TimeSpan = d2.Subtract(d1)
Console.WriteLine("Difference between these two times is:" & vbCr & vbLf & "years: {0}" & vbCr & vbLf & "months: {1}" & vbCr & vbLf & "days: {2}", Math.Round(ts.TotalDays / 366, 1), Math.Round(ts.TotalDays / 31), ts.TotalDays)

I agree you must be entering the wrong syntax...

e.g. I want to find the difference between date1 and date2 in days,
datediff( day, date1, date2)

I want to know the difference in Hours datediff( hour, date1, date2)

if u are entering the datediff as years then it will show 1 yr as 2011 and 2012 has a diff of 1....

I need it in years in a way that it shows 1 only if actually an year has passed ,,otherwise 0(as with above parameters)

then first calculate the number of days and check if actually its greater than 365 days then u can use what u want....

 Dim d1 As New DateTime(2010, 12, 31)
        Dim d2 As New DateTime(2012, 1, 1)
        Dim days As Long
        days = DateDiff("d", d1, d2)
        Debug.Print(days.ToString & " Days")
        If days < 365 Then
            MsgBox("Year not completed")
        Else
            MsgBox("Year completed")
        End If

U 're not getting it maybe..I need to get the digit returned and then it will be inserted into column and the two dates are such that one is the current date and other we get from one of the datetimepicker textbox

Yes so instead of displaying the msgbox u can keep a track of the number of years...

Check the scneario what I have done...

2 datetimepicker - 1 with current date and the second that will be derived from datetimepicker2

one label that will give the number of years only if it has completed the year.

Private Sub DateTimePicker2_ValueChanged(sender As System.Object, e As System.EventArgs) Handles DateTimePicker2.ValueChanged

    Dim d1 As DateTime = DateTimePicker1.Value
    Dim d2 As DateTime = DateTimePicker2.Value
    Dim Year1 As Integer
    Dim days As Long
    days = DateDiff("d", d2, d1)
    Debug.Print(days.ToString & " Days")
    If days < 365 Then
        Year1 = 0
    Else
        Year1 = days / 365
    End If
    Label1.Text = Year1.ToString
End Sub

Hope this is what u need

Can you use DateTime and TimeSpan?
They've never failed me.

I have used datetime...in this timespan wont be required...right??? coz he just wants the days....

When you subtract a DateTime from a DateTime, it creates a TimeSpan.

Module Module1
   Sub Main()
      Dim dtOne As New DateTime(2011, 12, 31) '31 Dec, 2011'
      Dim dtTwo As New DateTime(2012, 1, 1) ' 1 Jan, 2012'
      Dim tsDiff As TimeSpan = (dtTwo - dtOne)
      ''
      System.Diagnostics.Debug.WriteLine(String.Format("DAYS={0}", tsDiff.Days))
   End Sub
End Module

The easiest way to do a calculation like that is to count the days.

Okkk...after getting the days from the timespan we can apply the condition and get what is required...

'" & DateDiff("yyyy", DateTimePicker1.Text, Now(), FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFourDays) & "'

ok this is the query..I need the result to be exact.By exact i mean it should only result in 1 when there is actual gap of 1 year not that one of the dates is dec.2011 and other jan. 2012 and i get 1 (which is actually what i am getting).hope i make myself clear

Please look into TimeSpan.

In that case you are misusing the term "exact". Unless you mean you want a result of 1 when the difference is exactly one year. If you are not interested in fractions of a year then do as was suggested and find the difference in days then take the integer portion and throw away the rest. That way you get the numbers

0-364 days = 0 years
365-729 days = 1 year
730-1094 days = 2 years
etc

here you go

‘” & Int(DateDiff("d", DateTimePicker1.Text, Now(), FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFourDays) / 365) & "'

 Dim BornDate As Date = DateTimePicker3.Value
 Dim Interval As TimeSpan = Now - BornDate
 Debug.Print("Interval: " + Interval.TotalDays.ToString)
 Dim years As Integer = Math.Truncate(Interval.TotalDays / 365)
 TextBox1.Text = years

This part will return exact one year difference if true
'datetimepicker3 is the value that will be changing
it has been compared with Todays date....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.