Conditions, dependent data

  • Thread starter Thread starter ineedhelp
  • Start date Start date
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
 
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
Click to expand...
Click to expand...
 
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top