How to add days to an existing date value

To create a column that displays date values that are greater than the date values in another column, complete the following steps.

1	Select a column. From the context menu, choose Column→Choose New Computed Column. New Computed Column appears.

2	In Column Label, type a name for the calculated column. For example, type Forecast Shipping Date.

3	In Enter Expression, type the letter A. A list appears, displaying functions that begin with A.

4	Choose ADD_DAY(date, daysToAdd).

5	For the first argument, type a left bracket ([) and select the date column from the list. For example, select Order Date.

6	For the second argument, type the number of days to add. In this case, type 7.

7	Validate the expression and choose OK. The calculated column appears in the report. For every value in the Order Date column, the calculated column displays a date seven days later than the order date.

Copyright Actuate Corporation 2012