Calculating dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to calculate a date by adding 3 years to an existing date on a form.
How do I due that and account for Leap years?
 
Wendell said:
I need to calculate a date by adding 3 years to an existing date on a form.
How do I due that and account for Leap years?
Click to expand...

Adding three years has nothing to do with leap years. If you add three
years onto April 3, 1999, you get April 3, 2002 even though 2000 was a leap
year. In any case, the DateAdd function will do it:

DateAdd("yyyy", 3, [Starting Date])

Tom Lake
 
Thanks!

Wendell

Tom Lake said:
Wendell said:
I need to calculate a date by adding 3 years to an existing date on a form.
How do I due that and account for Leap years?
Click to expand...

Adding three years has nothing to do with leap years. If you add three
years onto April 3, 1999, you get April 3, 2002 even though 2000 was a leap
year. In any case, the DateAdd function will do it:

DateAdd("yyyy", 3, [Starting Date])

Tom Lake
Click to expand...
 

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

Excel DateDif - why does 2007 seem different? 3
Error in Excel date calculations 3
calculating datew with leap years 2
Function to calculate number of Wednesdays in time interval 1
Determine if Leap Year 12
Creating an update query that uses multiple parameters 2
calc. an anniversary date(50 years) after marriage date in excel 3
Handling Leap Years 3

Back
Top