Adding and Subtracting Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field called TIME. It is formatted as Date/Time, and "Long Time".
I want to know 10 minutes before, and 10 minutes after the value in Time.
I've tried DateDiff with limited success.
Any Ideas?

Thanks!
 
DateDiff tells you the difference between two values. DateAdd does the
arithmetic...

DateAdd("n", 10, [MyTimeField]) will add 10 minutes, DateAdd("n", -10,
[MyTimeField]) will subtract 10 minutes

BTW, you should rename your field. Time is a reserved word, and you can run
into problems using reserved words for your own purposes. As well, just in
case you weren't aware, even if all you've supplied is a time, the field
will contain a date as well. With no date supplied, Access is going to
assume a date of 30 Dec, 1899.
 
Worked Great!
Thanks!

I wish I could rename TIME, but it's being converted from a device that uses
that word. Maybe I could import the info under a different name....I'll play
with it.
Thanks again for the advice.
Jesse

Douglas J. Steele said:
DateDiff tells you the difference between two values. DateAdd does the
arithmetic...

DateAdd("n", 10, [MyTimeField]) will add 10 minutes, DateAdd("n", -10,
[MyTimeField]) will subtract 10 minutes

BTW, you should rename your field. Time is a reserved word, and you can run
into problems using reserved words for your own purposes. As well, just in
case you weren't aware, even if all you've supplied is a time, the field
will contain a date as well. With no date supplied, Access is going to
assume a date of 30 Dec, 1899.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



cutthroatjess said:
I have a field called TIME. It is formatted as Date/Time, and "Long Time".
I want to know 10 minutes before, and 10 minutes after the value in Time.
I've tried DateDiff with limited success.
Any Ideas?

Thanks!
Click to expand...
Click to expand...
 
Back
Top