Using DatePart(interval, date[,firstdayofweek[, firstweekofyear]]) to Parse Dates : DatePart « Date Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Date Functions
  3. DatePart

Using DatePart(interval, date[,firstdayofweek[, firstweekofyear]]) to Parse Dates

 
Constant         Value      Year Starts with Week         
vbUseSystem      0          Use the system setting.        
vbFirstJan1      1          The week in which January 1 falls (the default setting).        
vbFirstFourDays  2          The first week with a minimum of four days in the year.        
vbFirstFullWeek  3          The first full week (7 days) of the year.      


the following statement assigns the current year to the variable dteThisYear:

Sub datePart()
    Debug.Print DatePart("yyyy", Date)
End Sub








Related examples in the same category

1.DatePart("q", Now)
2.DatePart("m", Now)
3.DatePart("d", Now)
4.DatePart("w", Now)
5.DatePart("ww", Now)
6.DatePart("h", Now)
7.DatePart("n", Now)
8.DatePart("s", Now)
9.DatePart returns 'Prints the Year
10.Prints the Month Number
11.Prints the Quarter Number
12.Prints the Day of the Year
13.Prints the Week of the Year
14.Break a single date down to its individual components using the DatePart function