Calculating a Date 30 Days From a Date Field (DB)

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
Sometimes you may want to use a calculation to determine the number of days from a specific date. For example, you may enter a purchase date and want to have a calculation add 30 days to determine the due date of the payment. Use the formula below to add 30 days to a field called PurchaseDate, where the result displays in a field called DueDate. The DueDate formula is

DueDate (Calculation, Date result) =
DATE(YEAR('PurchaseDate'), MONTH('PurchaseDate'), DAY('PurchaseDate'))+30
Published Date: Feb 18, 2012