asked on
Hello all,
I'm running a report at X time every Y hours. Each time the report runs my vb.net windows form application calculates the next run time and stores that datetime. I anticipated some drift of time where the report will get progressively later in the day so I kept the original "base time" as a field in the database for this record. I'm trying to figure out a way to measure if the next run time is more than a minute past the "base time" and if so force the next run time back to the base time. Aircode:
If nextRunTIme(hh:mm) - BaseTime(hh:mm) > 1 then
NetRunTime = correct NextRunTime Date but BaseTime Hours:Minutes
End If
In other words:
If NextRunTime (12/24/2012 9:05 PM) - BaseTIme(9/12/2012 9:00 PM) > 1 Then
NextRunTime = 12/24/2012 9:00 PM
End If
Take the date from NextRunTime but the TIME from BaseTime?
Thanks
I'm running a report at X time every Y hours. Each time the report runs my vb.net windows form application calculates the next run time and stores that datetime. I anticipated some drift of time where the report will get progressively later in the day so I kept the original "base time" as a field in the database for this record. I'm trying to figure out a way to measure if the next run time is more than a minute past the "base time" and if so force the next run time back to the base time. Aircode:
If nextRunTIme(hh:mm) - BaseTime(hh:mm) > 1 then
NetRunTime = correct NextRunTime Date but BaseTime Hours:Minutes
End If
In other words:
If NextRunTime (12/24/2012 9:05 PM) - BaseTIme(9/12/2012 9:00 PM) > 1 Then
NextRunTime = 12/24/2012 9:00 PM
End If
Take the date from NextRunTime but the TIME from BaseTime?
Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.