Why would changing the time format make any difference? In fact, wouldn't this potentially cause the process to happen multiple times when it's only wanted once? Or does the "100" mean ten seconds, or something?
I dont think its such a weird idea, i think that while working with dates, its better to use an interval in the IF rather than an exact time.
i.e.
you may be so lucky that if you say
- If MyTime = "2:30 AM" then
-
'Do something
-
End if
Will work if the timer tics in that very moment
But i'd say that something like:
-
if mytime >= "2:30 AM" and mytime < "2:31 AM" then
-
'Do something
-
End if
with a larger interval will do
But since you dont know the speed of the users computer, to make sure the event will only happen once, but it'll certainly happen, write (inside the timer) something like
- Dim Boo1 as boolean
-
If mytime <= "2.30 AM" then boo1=true
-
if mytime >= "2.30 AM" and Boo1 = true then
-
'Do something
-
boo1=false
-
end if
or any other variant of "using a boolean to only do it once" will help.