How to manipulate time in VB?

[229257]

Hi,

I'm querying some time values from an Access DB in VB, the format that the time is in looks like is 12:21:20, hh:mm:ss. I would like to simply add or subtract a minute on the time meeting a certain conidition e.g. 12:21:20 + 00:01:00 but all i get is a mismatch message. I think it would help if I stored the time in a variable before manipulating it but what variable type do i use?

Any help would be much appreciated.

Thanks

 

[bjd4jc]

Please post code that you have so far.

 

[229257]

Here's an example;

Dim tempStartTime as string
'dont think is correct but couldnt think a suitable one.

tempStartTime = DatGeneralAmIns.recordset!starttime
'now holds 10:02:00

tempStartTime = tempStartTime + 00.01

Any ideas? thanks.

 

[bjd4jc]

Check out the DateAdd Function

tempStartTime = DateAdd("n", 1, tempStartTime)

 

[229257]

Great stuff,

Many thanks

229257