Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Past Work Date
rjoubert I see were you are going but can DateAdd be written as DateADD("d",[MfgTime],[OrigShDate])? ================== Golom In your Code can TheDate = [MfgTime]? I need for the qty in [MfgTime] to be subtraced from [OrigShDate] Since each product has a different number of day for...- usmcret
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Past Work Date
I have a Field called [MfgTime] I want to subtract this number from [OrigShDate]. example [OrigShdate]- [MfgTime] = [OrigJGDate] 08/01/06 - 3 (days) = 08/27/06 This should exclued WeekEnds. I have found all kinds of formulas that add to the date but none to subtract. Thank you- usmcret
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
