Add Time

[Dina01]

I have a textbox named txtHrsDebut what I would like to do is add 30 minutes to that time and then save.

Can anyone tell me how to do this....

 

[Shane_Mc]

Not quite sure. But there is a DateAdd function. The following line of code is used to get a date 7 days before the current date.


DateAdd("y",-7,Date())

I presume you could try something similar using or search for the TimeAdd function (if there is one!)

 

[Dina01]

This is my code, but it keeps on returning -1

If Me.description = "15 minutes" Then
txtTime15 = DateAdd("m", 15, [HrsRecu])
Else
txtTime30 = DateAdd("m", 30, [HrsRecu])
End If

 

[Dina01]

Found Solution

I was able to find the error, I just had to replace the m by n..

Thanks