Date Add

[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

 

[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)

 

[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!

 

[Klatuu]

What I posted will do exactly that.

 

[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.

 

[Klatuu]

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