Calculated Date Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I would like to create a calculated field that adds 30 days to another date
field.

For example:

Invoice Date = 11/15/06
$100 due by 12/15/06
$105 due if paid 12/16/06 or later.

The due dates are calculated fields based on the invoice date. In other
words, I want to add 30 days and 31 days respectively.

Thanks
 
Hi Fini2549,

Use the dateadd function eg:

dateadd("d", 30, INVOICEDATE)

Hope this helps.

Damian.
 
Back
Top