ADD_DAY( )
Adds a specified number of days to a date value.
Syntax
ADD_DAY(date, daysToAdd)
Arguments
date
The date or date expression that represents the start date.
daysToAdd
The number of days 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 specified number of days to the start date.
Example
The following example adds 15 days to each date value in the InvoiceDate data field:
ADD_DAY([InvoiceDate], 15)

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2