| DatePart Function |
Named Arguments
Yes
Syntax
DatePart(interval, date[,firstdayofweek[, _
firstweekofyear]])interval
Use: Required
Data Type: String
The unit of time to extract from within date (see the table Section 7.54.3).
date
Use: Required
Data Type: Variant (Date)
The Date value that you want to evaluate.
firstdayofweek
Use: Optional
Data Type: Numeric constant
A numeric constant that defines the first day of the week. If not specified, Sunday is assumed (see the table Section 7.54.4).
firstweekofyear
Use: Optional
Data Type: Numeric constant
A numeric constant that defines the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs (see the table Section 7.54.5).
Interval Settings
| Setting | Description |
|---|---|
yyyy | Year |
q | Quarter |
m | Month |
y | Day of year |
d | Day |
w | Weekday |
ww | Week |
h | Hour |
n | Minute |
s | Second |
First Day of the Week Constants
First Week of Year Constants
Return Value
Variant (Integer)
Description
Extracts an individual component of the date or time (like the month or the second) from a date/time value. It returns a Variant (Integer) containing the specified portion of the given date. DatePart is a single function encapsulating the individual Year, Month, Day, Hour, Minute, and Second functions.
Rules at a Glance
The firstdayofweek argument affects only calculations that use either the "w" or "ww" interval values.
Example
Dim sTimeInterval As String
Dim dtNow As Date
sTimeInterval = "n" 'minutes
dtNow = Now
MsgBox DatePart(sTimeInterval, dtNow)Programming Tips and Gotchas
When working with dates, always check that a date is valid using the IsDate function prior to passing it as a function parameter.
If you specify date within quotation marks (" ") omitting the year, the year is assumed to be the current year taken from the computer's date.
If you attempt to extract either the hours, the minutes, or the seconds, but date1 doesn't contain the necessary time element, the function assumes a time of midnight (0:00:00).