ADD_WEEK( )
Adds a specified number of weeks to a date value.
Syntax
ADD_WEEK(date, weeksToAdd)
Arguments
date
The date or date expression that represents the start date.
weeksToAdd
The number of weeks to add to the start date. If you specify a negative number, the result appears to subtract the number from the start date.
Returns
The date value that results from adding the number of weeks to the start date.
Example
The following example adds two weeks to each date value in the OrderDate data field:
ADD_WEEK([OrderDate], 2)

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2