Date Add

L

lmossolle

I have a date field called rqrdate, i have another field called reqdays, I
would like to add the together, could someone assist?

Thanks,

Lee
 
K

Klatuu

If what you are saying is you want to add the number of days in the field
reqdays to the date field rqrdate to create a date in the future then you use
the DateAdd function:

=DateAdd("d", reqdays, rqrdate)
 
L

lmossolle

Sir,

I want to add the 2 fields together and display a calander date. the
rqrdate is the date recieved, the reqdays is total days to complete. So if a
rqrdate was 20-July-2008, and the reqdays was 7 it would show 27-July-2008.

Thanks!
 
J

Jason

what about rqrdate + reqdays? I've always used this method to add days. I
use other methods to work with months particularly 20th of the month, last
day of month, 1st day of month.
 
K

Klatuu

Although that will work, I consider it poor form. I recommend when working
with date values to use the intrinsic date functions.
 
Top