This probably sounds really silly but how can I increase a time value whilst maintaining the time rules (60 mins per hour). I noticed that I can do:
Date + 7
without any problems but it won't do:
Time + 30
Help, please!!!!
Printable View
This probably sounds really silly but how can I increase a time value whilst maintaining the time rules (60 mins per hour). I noticed that I can do:
Date + 7
without any problems but it won't do:
Time + 30
Help, please!!!!
Assuming you mean in a VB date variable, use:
Dim dtNew as date
Dim dtOld as date
dtOld = Now()
dtNew = DateAdd("n",30,dtOld)
where "h" =hours, "n" = minutes, "s" = seconds
HTH,
Duncan
-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com
Excellent!! Thank you very much!!