Compare current time to a separate date and time DB field
Posted on 2003-10-24
I am struggling with something in VB, here is a summary of what I am having trouble with.
I retrieve 2 separate date and time fields from a database, and the date is in the format 17-OCT-2003 (for example) and the time is military format 09:30 (example).
I need to compare this time against the current system time inside my VB 6 application, and then move a file from one directory
to another if the current data and time is >= the time and date I got from the database. I am not finding anything yet
in VB docs on how to get different components of the system time, the only thing I found was some constant "NOW", which
gives 1 long date time stamp. Is there something that can give me the date in this format, and also the time in military time
that will allow me to compare the 2?