VB .NET Language in a Nutshell

Name

DatePart Function

Class

Microsoft.VisualBasic.DateAndTime

Syntax

DatePart(interval, datevalue[,firstdayofweekvalue[, _
        firstweekofyearvalue]])

interval

Use: Required

Data Type: String or a member of the DateInterval enum

A String literal (see the second item in Section ) or a constant of the DateInterval enum (see the third item in Section ) that defines the part of the date/time to extract from datevalue

datevalue

Use: Required

Data Type: Date, literal date, or an expression capable of conversion to a date

The Date value to evaluate

firstdayofweekvalue

Use: Optional

Data Type: FirstDayOfWeek enum

A member of the FirstDayOfWeek enum

firstweekofyearvalue

Use: Optional

Data Type: FirstWeekOfYear enum

A member of the FirstWeekOfYear enum

Return Value

An Integer containing the specified part

Description

Extracts an individual component of the date or time (like the month or the second) from a date/time value

Rules at a Glance

• The DatePart function returns an 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.

• interval can be one of the following literal strings:

String	Description
yyyy	Year
q	Quarter
m	Month
y	Day of year
d	Day
w	Weekday
ww	Week
h	Hour
n	Minute
s	Second

• interval can also be a member of the DateInterval enum:

  Enum DateInterval
     Day
     DayOfYear
     Hour
     Minute
     Month
     Quarter
     Second
     Week
     Weekday
     WeekOfYear
  End Enum

• The firstdayofweekvalue ...