DATEADD





This function adds a value to a date.

Parameters:

  • Expression. Type: Date.
  • Increment type. A string containing one of the following values:
  • Second
  • Minute
  • Hour
  • Day
  • Week
  • Month
  • Quarter
  • Year
  • TenDays
  • HalfYear
  • Size. The size of date increment. Type: Number. Fractions are ignored.

DATEADD(DATETIME(2009, 10, 12, 10, 15, 34), "Month", 1)

Result:

 11/12/2009 10:15:34 AM


Comments
0
Add comment