Thread: Hour addition
View Single Post
  #4  
Old July 27th 07, 04:34 PM posted to autodesk.autocad.customization.vba,microsoft.public.access.modulesdaovba,microsoft.public.outlook.program_vba
Graham R Seach
external usenet poster
 
Posts: 1
Default Hour addition

Al,

No need for a loop:
dteMyTime = DateAdd("h", 8, dteMyTime)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


"Al" wrote in message
9.11...
We have a program that trends our current plant steam usage and uses VBA
for applications. I'd like to use the do...loop and loop it until I reach
a time 8 hours away.

How do I add 8 hours to the currect time?

Thanks


Ads