Simple Time Question...

W

Wolfsnap

Newcomer
Joined
Jun 15, 2003
Messages
19
Location
North Carolina
I'm really getting confused here. What I want to do is execute somecode when the time is later than 11:59:59 PM. (an end of the day wrap up, in essence)

Help!

Is there a way to convert the time into an integer and then check to see if it's more then 115959? (or 235959, I guess)?
 
Nevermind - I got it. (don't know how to delete this thread)

If TimeOfDay >= #11:59:55 PM# Then
MsgBox("The current time is within 5 seconds of midnight" & _
vbCrLf & "The timer returns to 0.0 at midnight")
Return
End If
 
Back
Top