[RESOLVED] Some doubts about DateDifference - calculating time

[akhileshbc]

Hi...

I need to use DateDiff() to calculate the difference in Time.

Private Sub Form_Load()
    Dim myDate1 As Date
    Dim myDate2 As Date
    
    Dim lngMin  As Long
    
    'mydate1 will hold another value
    myDate2 = Now
    
    lngMin = DateDiff("n", myDate1, myDate2)
    Me.Caption = lngMin

End Sub

Here, myDate1 will hold a date value stored some days before.(using Now() function).

Will there be any problems with this calculation. I heard that there's an issue with midnight time. What's it ? Can anybody explain it ?

Thanks in advance...