New Field -- Date Field + 10 years formula needed.

C

Chad Graybill

This is probably a quick snap from what I have read from the experience of
some of the posts in this newsgroup.

I need to create a formula (I guess in a query) that takes (Manuf Date)
(ex.12/01/2003) and add 5 years to make a new field called (Next Test Date).

Can someone help me?

Thanks in advance, from an Access Hacker.

Chad Graybill
[email protected]
 
C

Connie

You may not want to go this way, but I have sometimes
calculated the number of days in the time period
needed..in your case 5 years (you have to take leap year
into consideration), and in a new column in the query, do
the following:

Your Field Name: [name of your date field]+ #of days

Could be a better way, but the above will work.
 
F

fredg

This is probably a quick snap from what I have read from the experience of
some of the posts in this newsgroup.

I need to create a formula (I guess in a query) that takes (Manuf Date)
(ex.12/01/2003) and add 5 years to make a new field called (Next Test Date).

Can someone help me?

Thanks in advance, from an Access Hacker.

Chad Graybill
[email protected]
Click to expand...

[Next Text Date] = DateAdd("yyyy",10,[Manuf Date])
 
F

fredg

This is probably a quick snap from what I have read from the experience of
some of the posts in this newsgroup.

I need to create a formula (I guess in a query) that takes (Manuf Date)
(ex.12/01/2003) and add 5 years to make a new field called (Next Test Date).

Can someone help me?

Thanks in advance, from an Access Hacker.

Chad Graybill
[email protected]
Click to expand...

[Next Text Date] = DateAdd("yyyy",10,[Manuf Date])
Click to expand...

Correction.
Your Subject line says + 10 years, but your message said + 5 years.

[Next Text Date] = DateAdd("yyyy",5,[Manuf Date])
 
G

Graham R Seach

Chad,

UPDATE tblMyTable SET [Next Test Date] = DateAdd("yyyy", 5, [Manuf Date])

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top