Add Number to a Date

  • Thread starter Thread starter Radhika
  • Start date Start date
R

Radhika

I am trying to add a number to a date. I have a field called 'Check Out Date'
and 'Check Out Duration'. I am trying to automatically calculate 'Return
Date' by adding 'Check Out Duration' to 'Check Out Date'. How can I go about
doing this?

Thankyou!
Radhika
 
I am trying to add a number to a date. I have a field called 'Check Out Date'
and 'Check Out Duration'. I am trying to automatically calculate 'Return
Date' by adding 'Check Out Duration' to 'Check Out Date'. How can I go about
doing this?

Thankyou!
Radhika
Click to expand...

use DateAdd. See help for details, because some of the "size" parts
are a bit misleading at first.
 
If Check Out Duration is a number of days you could use DateAdd:
In an empty column in query design view:
ReturnDate: DateAdd("d",[CheckOurDuration],[CheckOutDate])

As the Control Source of an unbound text box on a form or report:
=DateAdd("d",[CheckOurDuration],[CheckOutDate])

If you mean something else, please clarify. I would have expted
StayDuration or VisitDuration rather than CheckOutDuration, so maybe I am
not seeing this as you intend.
 
Thanyou! That was exactly what I needed.

Radhika

BruceM said:
If Check Out Duration is a number of days you could use DateAdd:
In an empty column in query design view:
ReturnDate: DateAdd("d",[CheckOurDuration],[CheckOutDate])

As the Control Source of an unbound text box on a form or report:
=DateAdd("d",[CheckOurDuration],[CheckOutDate])

If you mean something else, please clarify. I would have expted
StayDuration or VisitDuration rather than CheckOutDuration, so maybe I am
not seeing this as you intend.

Radhika said:
I am trying to add a number to a date. I have a field called 'Check Out
Date'
and 'Check Out Duration'. I am trying to automatically calculate 'Return
Date' by adding 'Check Out Duration' to 'Check Out Date'. How can I go
about
doing this?

Thankyou!
Radhika
Click to expand...
Click to expand...
 
Back
Top