DateAdd Function

[DMFisher]

Hi

Is it possible to automatically calculate a date (+6 months from another cell in the same record) in a table. I have previously used the DateAdd function in a form but this does not seem to update the table.

 

[StephenCrump]

In Excel, EDATE(start_date,6) will calculate the date 6 months forward. If used in a Table, the formula should automatically fill down.

But I'm not sure this answers your question given you refer to DateAdd and "form" which suggests you're doing something in VBA?

 

[StephenCrump]

Sorry, ignore previous post.

I searched Zero Reply Posts, and didn't notice this was (clearly!) in the Access Forum.

 

[Anand Sharma]

You can try below code which gives you flexibility to add month/year/day

=DATE(YEAR(A2)+6,MONTH(A2),DAY(A2))

 

[Norie]

If you want to update the table you would need to run an UPDATE query.

Remember though the change would be permanent an you would need to redo things whenvever records were added/changed.

 

[DMFisher]

How do I set up an update query? (Sorry I'm not too familiar with Access)