Link to home
Start Free TrialLog in
Avatar of isnoend2001
isnoend2001Flag for United States of America

asked on

error type mismatch vb6

getting an error "By reference mismatch" when trying to call this function:

Function DetermineNextTaskTime(dteTaskTime As Date) As String
Dim dteTaskTimeTom As Date
Dim dteTimeNow As Date
Dim lngDifference As Long
Dim lngHours As Long
Dim lngMinutes As Long

dteTimeNow = TimeValue(Now)
' This is set up for a 9AM task
'dteTaskTime = TimeValue("9:00") ' assumes military time
dteTaskTime = TimeValue(dteTaskTime) ' assumes military time

If dteTimeNow > dteTaskTime Then
    ' Format a date+time value that represents the task time tomorrow
    dteTaskTimeTom = Format(Now + 1, "short date") & " " & dteTaskTime
    lngDifference = Abs(DateDiff("s", dteTaskTimeTom, Now))
Else
    lngDifference = DateDiff("s", dteTimeNow, dteTaskTime)
    lngHours = (lngDifference \ 60) \ 60
    lngMinutes = (lngDifference - (lngHours * 60 * 60)) \ 60
End If

lngHours = (lngDifference \ 60) \ 60
lngMinutes = (lngDifference - (lngHours * 60 * 60)) \ 60
'MsgBox "Task due in " & lngHours & " Hours and " & lngMinutes & " Minutes"
DetermineNextTaskTime = lngHours & lngMinutes
End Function)

Open in new window


gNewTime = "09:00 AM"
 .TextMatrix(LastRow, mgrdNxtDueDate) = DetermineNextTaskTime(gNewTime

what is wrong ?
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of isnoend2001

ASKER

Thanks that byval worked