is there a DateSubtract too? I need to subtract hours from a time field.
T Tom Lake Aug 26, 2005 #2 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 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
S Steve Schapel Aug 28, 2005 #3 Sash, Use the DateAdd function, with a -ve amount entered for the 'number' argument, for example... DateAdd("h",-3,[YourField])
Sash, Use the DateAdd function, with a -ve amount entered for the 'number' argument, for example... DateAdd("h",-3,[YourField])
