Loading lesson path
Concept visual
Start at both ends
Return the year part of the specified date:
SELECT DatePart("yyyy", #09/05/2017#);The DatePart() function returns a specified part of a date, as an integer.
datepart, date, firstdayofweek, firstweekofyear )
Required. The date part to return. Can be one of the following values:
Formula
yyyy = Year q = Quarter m = month y = Day of the year d = Day w = Weekday ww = Week h = hour n = Minute s = Second dateRequired. The date value to be evaluated firstdayofweek Optional. Specifies the first day of the week. Can be one of the following values:
Formula
0 = Use the NLS API setting
1 = Sunday (default)
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday firstdayofyearOptional. Specifies the first week of the year. Can be one of the following values:
Formula
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 yearReturn the month part of the specified date:
SELECT DatePart("m", #09/05/2017#);Return the weekday of today's date:
SELECT DatePart("w", Date());❮ MS Access Functions