dates problem

  • Thread starter Thread starter bogi
  • Start date Start date
B

bogi

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
 
Back
Top