Calculated Date Field

[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

 

[Guest]

Hi Fini2549,

Use the dateadd function eg:

dateadd("d", 30, INVOICEDATE)

Hope this helps.

Damian.