Adding Minutes to Time Function

[Xcelsoft]

I have a database that sends faxes with win fax pro. On
a form there is a control where VB picks up the Time. Is
there a way to add let's say 2 minutes to this time?
Kind of like the DateAdd function but for time.


Thanks,

ET Sherman

 

[Douglas J. Steele]

While perhaps not obvious, the DateAdd function does work for time.

See
http://msdn.microsoft.com/library/en-us/office97/html/output/f1/d6/s5b206.as
p for details.

(Don't worry that it's from the Office 97 documentation: it's the same in
all versions)

 

[Van T. Dinh]

Assuming you are talking about an Access database then check Access VB Help
on the DateAdd() function.

 

[Roxie Aho]

-----Original Message-----
I have a database that sends faxes with win fax pro. On
a form there is a control where VB picks up the Time. Is
there a way to add let's say 2 minutes to this time?
Kind of like the DateAdd function but for time.


Thanks,

ET Sherman

=DateAdd("n",2,[txtTime])
The "n" stands for for minutes.

Roxie Aho
roxiea at usinternet.com