Returns the specified part of a given date.
|
---|
DatePart(interval, date[, firstdayofweek[, firstweekofyear]]) |
Arguments
- interval
Required. String expression that is the interval of time you want to return. See Settings section for values.
- date
Required. Date expression you want to evaluate.
- firstdayof week
Optional. Constant that specifies the day of the week. If not specified, Sunday is assumed. See Settings section for values.
- firstweekofyear
Optional. Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs. See Settings section for values.
Settings
The interval argument can have the following values:
Setting
|
Description
|
---|
yyyy | Year |
q | Quarter |
m | Month |
y | Day of year |
d | Day |
w | Weekday |
ww | Week of year |
h | Hour |
n | Minute |
s | Second |
The firstdayofweek argument can have the following values:
Constant
|
Value
|
Description
|
---|
vbUseSystemDayOfWeek | 0 | Use National Language Support (NLS) API setting. |
vbSunday | 1 | Sunday (default) |
vbMonday | 2 | Monday |
vbTuesday | 3 | Tuesday |
vbWednesday | 4 | Wednesday |
vbThursday | 5 | Thursday |
vbFriday | 6 | Friday |
vbSaturday | 7 | Saturday |
The firstweekofyear argument can have the following values:
Constant
|
Value
|
Description
|
---|
vbUseSystem | 0 | Use National Language Support (NLS) API setting. |
vbFirstJan1 | 1 | Start with the week in which January 1 occurs (default). |
vbFirstFourDays | 2 | Start with the week that has at least four days in the new year. |
vbFirstFullWeek | 3 | Start with the first full week of the new year. |
Remarks
Requirements
See Also