calculations on date

[harrie]

i have a start_date in format mm/dd/yyyy , then i create attributes called N_O_D and end_date

example ::

start_date N_O_D end_date
11/20/2016 3 11/22/2016


if i key in 4 in N_O_D , then the end_date becomes 11/23/2016
if i key in 12 , end_date becomes 12/01/2016


how to do the calculation on date ?

[John_G]

You haven't given us much to work with. If these are fields in a table, don't store the end date. Store only the Start_Date and N_O_D, and calculate the End_Date in a query, using the DateDiff function.

PS - the format of the start date (or any date) is only for display. It is not stored in the database table in that format.

[ssanfu]

When you say

if i key in 4 in N_O_D , then the end_date becomes 11/23/2016
if i key in 12 , end_date becomes 12/01/2016

is this in a table, query or form?

Also look at the DateAdd Function

[harrie]

John_G ← thx, i success do it with your guide.
ssanfu ← N_O_D is in the table whereby it can be key in by user in any values.

and i solved it , thx