Conditions, dependent data

[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

 

[Wayne-I-M]

=DateAdd("d", 90, [Payment date])

 

[ineedhelp]

Thank you! Where do I put this formula?

=DateAdd("d", 90, [Payment date])


--
Wayne
Manchester, England.

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

 

[冯永凯]

很好

 

[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
ExtendedDateateAdd("d", 90, [TableName]![Payment date])

Change TableName to what it really is




--
Wayne
Manchester, England.

Thank you! Where do I put this formula?

=DateAdd("d", 90, [Payment date])


--
Wayne
Manchester, England.

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