DatePart Function |
Yes
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).
Setting | Description |
---|---|
yyyy | Year |
q | Quarter |
m | Month |
y | Day of year |
d | Day |
w | Weekday |
ww | Week |
h | Hour |
n | Minute |
s | Second |
Variant (Integer)
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.
The firstdayofweek argument affects only calculations that use either the "w" or "ww" interval values.
Dim sTimeInterval As String Dim dtNow As Date sTimeInterval = "n" 'minutes dtNow = Now MsgBox DatePart(sTimeInterval, dtNow)
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).