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 | Office 2013

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.

DatePart

year

quarter

month

dayofyear

day

week

weekday

hour

minute

second

millisecond

Show: