DATEADD

DATEADD takes three arguments: a control string, an integer delta value, and a timestamp value. It returns a timestamp that applies the delta value to the specified part of the original timestamp. The operation carries if the sum of the original field value and the delta is illegal:

Timestamp DATEADD( control Varchar, delta Integer, value Timestamp )

Example

The following code:

SELECT ORDERS.ORDERID, ORDERS.SHIPBYDATE,
DATEADD('d', 14, ORDERS.SHIPBYDATE) AS ExpectedDelivery

FROM "../Data Sources/MyDatabase/ORDERS.SMA" ORDERS

returns:

1645,1995-05-22 00:00:00.0,1995-06-05 00:00:00.0

1340,1995-06-03 00:00:00.0,1995-06-17 00:00:00.0

1810,1995-04-12 00:00:00.0,1995-04-26 00:00:00.0

…

Copyright Actuate Corporation 2012