Conditions, dependent data


I

ineedhelp

I am creating a database containing sales information. I have a field
containing all of the different payment dates, and another field that will
contain the date that the warranty for the product runs out, and customers
will have to start paying the maintenance and support rate. This date is 90
days after the payment date. Is there a way of formatting or conditioning the
field to add 90 days to the date in the cell that contains the payment date?
So that the warranty expiry date is automatically calculated and entered into
each cell.

E.g.

Payment date
01/03/2008

Warranty expires
29/05/2008

Thank you
 
Ad

Advertisements

I

ineedhelp

Thank you! Where do I put this formula?

Wayne-I-M said:
=DateAdd("d", 90, [Payment date])


--
Wayne
Manchester, England.



ineedhelp said:
I am creating a database containing sales information. I have a field
containing all of the different payment dates, and another field that will
contain the date that the warranty for the product runs out, and customers
will have to start paying the maintenance and support rate. This date is 90
days after the payment date. Is there a way of formatting or conditioning the
field to add 90 days to the date in the cell that contains the payment date?
So that the warranty expiry date is automatically calculated and entered into
each cell.

E.g.

Payment date
01/03/2008

Warranty expires
29/05/2008

Thank you
 
Ad

Advertisements

W

Wayne-I-M

If you have a control called PaymentDate on a form create a new text box - or
use one you already have use this as the source
=DateAdd("d", 90, [Payment date])

Note the control name may not be the same name as the field it is bound to.

In a query you would create a calculated column and use
ExtendedDate:DateAdd("d", 90, [TableName]![Payment date])

Change TableName to what it really is




--
Wayne
Manchester, England.



ineedhelp said:
Thank you! Where do I put this formula?

Wayne-I-M said:
=DateAdd("d", 90, [Payment date])


--
Wayne
Manchester, England.



ineedhelp said:
I am creating a database containing sales information. I have a field
containing all of the different payment dates, and another field that will
contain the date that the warranty for the product runs out, and customers
will have to start paying the maintenance and support rate. This date is 90
days after the payment date. Is there a way of formatting or conditioning the
field to add 90 days to the date in the cell that contains the payment date?
So that the warranty expiry date is automatically calculated and entered into
each cell.

E.g.

Payment date
01/03/2008

Warranty expires
29/05/2008

Thank you
 

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

Top