0 out of 3 rated this helpful - Rate this topic

DatePart Function (Access 2013 custom web app)

Office 2013

Published: July 16, 2012

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

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.