calculate no if days from 2 dates

[696796]

    Public Sub calculateDays()
        ' Calendar Days
        Dim dtpDateCarSent As New DateTime
        Dim dtpDateClosed As New DateTime
        Dim dys As Integer = dtpDateClosed.Date.Subtract(dtpDateCarSent.Date).Days
    End Sub

Hi, im trying to use the above code but it isnt working... I am trying to calculate the no of days between two dates that i choose on my form using a dateTimepicker control. So for example if dateCarSent is 01/01/2006 and dateCarClosed is 05/01/2006, the answer would be 4 days.

Any help much apreciated,

Al

 

[696796]

got it...

Dim lngHowLong As Long
Dim date1 As Date = dtpDateCarSent.Text
Dim date2 As Date = dtpDateClosed.Text

lngHowLong = DateDiff("d", date1, date2)
MsgBox("There are " & lngHowLong & " days between the two dates.")

 

[chiph]

You should just be able to do this:

Dim dys As Integer = (dtpDateClosed.Subtract(dtpDateCarSent)).Days

This works because the subtraction method (operator in C#) returns a TimeSpan object, which has a Days property. The parenthesis help the compiler understand that you want the Days property of the result of the subtraction.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first