How to: Reference: |
Given a date in standard date or date-time format, DTADD returns a new date after adding the specified number of a supported component. The returned date format is the same as the input date format.
DTADD(date, component, increment)
where:
Date or date-time
Is the date or date-time value to be incremented.
Keyword
Is the component to be incremented. Valid components (and acceptable values) are:
Integer
Is the value (positive or negative) to add to the component.
DTADD adds three days to the employee date of birth:
DTADD(DATE_OF_BIRTH, DAY, 3)
For 1976/10/21, the result is 1976/10/24.
iWay Software |