dateadd

Returns the date resulting from adding "integer_expression" units indicated by datepart (day, month, year) to "date_expression". Note that "datepart" must be enclosed in curly brackets.

dateadd ( ' { ' datepart ' } ' , integer_expression ,
 date_expression )

dateadd ( {dd} , 16 , 1997-06-16 )