DateAdd Function (Access custom web app)

Office 2013 and later

Returns a specified date with the specified number interval (positive or negative integer) added to a specified date part of that date.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

Note Note

The cloud storage feature described in this article is no longer supported in Office 2013 and Office 2016 and may result in the following error:

Sorry, we’re having server problems, so we can’t add <service> right now. Please try again later.

For cloud storage for Office Online, Office for iOS, and Office for Android, you can look into our Office Cloud Storage Partner Program.

DateAdd(DatePart, Number, Date)

The DateAdd function contains the following arguments.

Argument name

Description

DatePart

The part of Date to which an integer number is added. Refer to the Remarks section for the list of valid settings.

Number

Is an expression that can be resolved to an integer that is added to a DatePart of Date. If you specify a value with a decimal fraction, the fraction is truncated.

Date

An expression that can be resolved to a Date/Time value. The Date argument expression, column expression, user-defined variable or string literal.

The following table lists all valid DatePart arguments.

DatePart

year

quarter

month

dayofyear

day

week

hour

minute

second

millisecond

The following expression calculates the last day of the current month.

DateAdd(Day,-1,DateAdd(Month,DateDiff(Month,0,Today())+1,0))

The following expression calculates the last day of the previous month.

DateAdd(Day,-1,DateAdd(Month,DateDiff(Month,0,Today()),0))
Show: