DateAdd

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

Guest

is there a DateSubtract too? I need to subtract hours from a time field.
 
Sash said:
is there a DateSubtract too? I need to subtract hours from a time field.
Click to expand...

You can use the DateAdd function to subtract dates, too. Just use a
negative of the hours you want to subtract.
Example: To subtract 2 hours from 5pm do this

? DateAdd("h", -2, #5:00pm#)
3:00:00 PM

Tom Lake
 
Sash,

Use the DateAdd function, with a -ve amount entered for the 'number'
argument, for example...
DateAdd("h",-3,[YourField])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Expression builder to manipulate dates 1
DateAdd compile error 1
using dateadd with iff 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
DateAdd ignoring Week-ends 4
Time Calculation thought process 8
Access Access Query 0

Back
Top