Date Add

  • Thread starter Thread starter lmossolle
  • Start date Start date
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
 
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)
 
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!
 
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.
 
Although that will work, I consider it poor form. I recommend when working
with date values to use the intrinsic date functions.
 
Back
Top