This function adds a number (a signed integer) to a datepart of an input date, and returns a modified date/time value. … DATEADD (Transact-SQL)Read more