dates problem

Hi, I have a table with records each with a certain dates,
I would like to make a report that gives me dates that are
one year ahead from the dates in the table (I want to
calculate the expiring warranty dates), I made a field in
a form that shows me that date, but I need to make a
report of it, can anyone help me, I can not write an
expression in querry that would return one year ahead
dates, can that be written with expression?
greetings

Try something like:

SELECT tblWarranties.Cust, DateAdd("yyyy",1,[WarrantyExpire])-1 AS
ExpiryDate, tblWarranties.WarrantyExpire
FROM tblWarranties;

From a table that includes a field for when the warranty began it returns a
date in 1 years time

eg. Warranty starts 3/3/04 the ExpiryDate = 2/3/05
In the above eg. if you wish to return 3/3/05 then remove the -1 from the
expression
i.e.
SELECT tblWarranties.Cust, DateAdd("yyyy",1,[WarrantyExpire]) AS ExpiryDate,
tblWarranties.WarrantyExpire
FROM tblWarranties

HTH


"bogi" wrote in message
...
Hi, I have a table with records each with a certain dates,
I would like to make a report that gives me dates that are
one year ahead from the dates in the table (I want to
calculate the expiring warranty dates), I made a field in
a form that shows me that date, but I need to make a
report of it, can anyone help me, I can not write an
expression in querry that would return one year ahead
dates, can that be written with expression?
greetings

thanks a lot Newbbie
it works great
by
Bogi