Printable View
Is there a simple way to <>= date and time?
I app which i cannot control outputs this format of date and time "9/26/2000 9:56:22 AM" I want to use this date and time in the follow code but don't exactly know what would be the best way. Any ideas?
The code below is a non working example but shows what i am trying to do:
Code:If TimeWritten = "9/26/2000 9:56:22 AM" Then GoTo ExitProc
If you are comparing dates as strings, you run into the problem of "01/01/99" < "02/02/34" (m/d/y). The most obvious way of getting around the problem is to re-define the strings to go in a y/m/d format.
If the dates are "real" dates, that is stored as numeric entities, then the visual format is irrelevant and the comparision should work as is.
I have some string functions that could help if you can't transform the dates.
Good Luck
DerFarm
Personaly, I would store the target date value into one variable and use a timer to test the currently displayed date with the target date. If the app constantly updates the time you will have to use a timer in some form or fashion. Either that or use an IfThen statement in your time stamp generator. I hope that helps. Good luck