Calculating dates

  • Thread starter Thread starter Steffie
  • Start date Start date
S

Steffie

I access, I have a field with a fixed date. In another
field I wish to calculate the same date 1 year ahead. How
do I do this?

Steffie
 
Hi,

With a computed expression:


DateAdd( "yyyy", 1 , YourStartingDate )



Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date calculation on 2 fields 5
Date Calculation 1
calculate two dates 1
Referencing a Caculated Field in another Calculated Field 4
Calculating a Date 1
Date Calculation 1
Excel DateDif - why does 2007 seem different? 3
Make query to calculate two dates 2

Back
Top