Add a number of days to a date in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

junior - 08 Mar 2005 23:43 GMT

i need help in adding "number of days" and "hiredate"(current day the movie
is borrowed), so that i can get the Duedate to display in the text box once i
click on the command button.

Reply to this Message

Dirk Goldgar - 09 Mar 2005 00:08 GMT

> i need help in adding "number of days" and "hiredate"(current day the
> movie is borrowed), so that i can get the Duedate to display in the
> text box once i click on the command button.

Use the DateAdd function. You'll find it in the online help. If
DueDate is entirely dependent on [Number of Days] and [HireDate] -- and
both those values are saved -- you don't really need to save the
calculated value. Just create a calculated control on your form with a
controlsource expression like this:

=DateAdd("d", [Number of Days], [HireDate])

Naturally, you'll have to replace "Number of Days" and "HireDate" with
the names of your own fields, if they are different.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message