Add Number to a Date

[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

 

[pietlinden]

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

use DateAdd. See help for details, because some of the "size" parts
are a bit misleading at first.

 

[BruceM]

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]

Thanyou! That was exactly what I needed.

Radhika

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.

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