DatePart Function (Access custom web app)

Office 2013 and later

Returns a numeric value that represents the specified date part of the specified date.

Last modified: March 09, 2015

Applies to: Access 2013 | Access 2016

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.

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.

Syntax

DatePart(DatePart, Date)

The DatePart function contains the following arguments.

Argument name	Description
DatePart	The part of Date (a date or time value) for which an integer will be returned. Refer to the Remarks section for the list of valid abbreviations.
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.