THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access DatePart() Function

❮ MS Access Functions

Example

Return the year part of the specified date:

SELECT DatePart("yyyy", #09/05/2017#);
Try it Yourself »

Definition and Usage

The DatePart() function returns a specified part of a date.

Syntax

DatePart(interval, date, firstdayofweek, firstweekofyear)

Parameter Values

Parameter Description
interval Required. The date part to return. Can be one of the following values:
  • yyyy = Year
  • q = Quarter
  • m = month
  • y = Day of the year
  • d = Day
  • w = Weekday
  • ww = Week
  • h = hour
  • n = Minute
  • s = Second
date Required. The date value to be evaluated
firstdayofweek Optional. Specifies the first day of the week. If omitted, Sunday is the first day of the week. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Sunday
  • 2 = Monday
  • 3 = Tuesday
  • 4 = Wednesday
  • 5 = Thursday
  • 6 = Friday
  • 7 = Saturday
firstdayofyear Optional. Specifies the first week of the year. If omitted, the week containing January 1st is the first week of year. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Use the first week that includes Jan 1st (default)
  • 2 = Use the first week in the year that has at least 4 days
  • 3 = Use the first full week of the year

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the month part of the specified date:

SELECT DatePart("m", #09/05/2017#);
Try it Yourself »

Example

Return the weekday of today's date:

SELECT DatePart("w", Date());
Try it Yourself »

❮ MS Access Functions