Adding years to a Date

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

Guest

I am using Access 2000
This concerns share options. I have a date the option was granted. I am
trying to use a query expression that will add 3 years and 7 years to the
issue date. I have found a function EDATE which adds months but does not work
in a query. If I add 3 X 365 days I get an answer but this is affected by
leap years.
Is there an expression which I can use which eg. will produce 08/01/07 from
an issue date of 08/01/04.
Many thanks for your help
Sean Bishop
 
Sean Bishop said:
I am using Access 2000
This concerns share options. I have a date the option was granted. I am
trying to use a query expression that will add 3 years and 7 years to the
issue date. I
Click to expand...
Is there an expression which I can use which eg. will produce 08/01/07
from
an issue date of 08/01/04.
Click to expand...

DateAdd("yyyy", 3, #08/01/04#)

will give 08/01/07

DateAdd("yyyy", 7, [Issue Date])

will add 7 years to the field Issue Date.

Tom Lake
 
Dear Tom,

Thank you for your reply. I had to reload Access to get the function. That
done it worked.
Many thanks
Sean Bishop
 
Hello,

I want to use the following

=DateAdd("d",180,[Date Referred])

=DateAdd("d",90,[Date Referred])

=DateAdd("yyyy",1,[Date Referred]).

When I put =DateAdd("yyyy",1,[Date Referred]) in the design view of the
table under default value however I'm getting the following error message
The database engine does not recognize either the field "Date Referred" in a
validation expression, or the default value in the table 'Tbl Client
Information'.

Where do I put the code?

Thanks Emma
 
Back
Top