Need Date Add Assistance

JSDART

Registered User.
Local time
Today, 23:25
Joined
Nov 20, 2000
Messages
18
Hi I have searched and have not found and answer.
I have a loan database and need to calculate a Due date for return.
The catch is that each item has a max days out number that the date is calculated on.

I have tried an unbound text box on the form with the following in it's control
=[loan date]+[max days out]
but I get #NAME in the box.
I'm thinking I should use DATEADD but it is not a stable number of dates it flucuates with the items max number of days out.

Any Suggestions
 
=DateAdd("d", CLng([YourMaxDays]), CDate([YourLoanDate]))
 

Users who are viewing this thread

Back
Top Bottom