VB.NET Language Pocket Reference

Name

DatePart Function — Microsoft.VisualBasic.DateAndTime

Synopsis

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

interval required; String or DateInterval enum

Defines the part of the date/time to extract from datevalue

datevalue required; Date, or an expression capable of conversion to a date

The Date value to evaluate

firstdayofweekvalue optional; FirstDayOfWeek enum

A member of the FirstDayOfWeek enum

firstweekofyearvalue optional; 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. 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:

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 argument can be any of the following members of the FirstDayOfWeek enumeration:

Enum FirstDayOfWeek
   System     'uses first day of week
              'setting on local system
   Sunday
   Monday
   Tuesday
   Wednesday
   Thursday
   Friday
   Saturday
End Enum

The firstdayofweekvalue argument affects ...