YouTip LogoYouTip

Vb Func Datepart

# VBScript DatePart Function * * Complete VBScript Reference Manual](#) * * * The DatePart function returns the specified part of a given date. ### Syntax DatePart(interval,date[,firstdayofweek[,firstweekofyear]]) | Parameter | Description | | :--- | :--- | | interval | Required. The time interval to return. Can take the following values: * yyyy - Year * q - Quarter * m - Month * y - Day of the year * d - Day * w - Day of the week * ww - Week of the year * h - Hour * n - Minute * s - Second | | date | Required. The date expression to calculate. | | firstdayofweek | Optional. Specifies the day of the week, i.e., which day of the week is considered the first day. Can take the following values: * 0 = vbUseSystemDayOfWeek - Uses the regional language support (NLS) API setting * 1 = vbSunday - Sunday (default) * 2 = vbMonday - Monday * 3 = vbTuesday - Tuesday * 4 = vbWednesday - Wednesday * 5 = vbThursday - Thursday * 6 = vbFriday - Friday * 7 = vbSaturday - Saturday | | firstweekofyear | Optional. Specifies the first week of the year. Can take the following values: * 0 = vbUseSystem - Uses the regional language support (NLS) API setting * 1 = vbFirstJan1 - Starts from the week containing January 1st (default) * 2 = vbFirstFourDays - Starts from the first week with at least four days in the new year * 3 = vbFirstFullWeek - Starts from the first full week in the new year | ## Examples ## Example 1 Get the month from a date: d=CDate("2010-02-16") document.write(DatePart("m",d)) The above example outputs: 2 [Try it Β»](#) ## Example 2 Get the month we are currently in: document.write(DatePart("m",Now())) The above example outputs: document.write(DatePart("m",Now())) [Try it Β»](#) ## Example 3 Get the hour: document.write(DatePart("h",Now()) The above example outputs: document.write(DatePart("h",Now())) [Try it Β»](#) * * Complete VBScript Reference Manual](#)
← Func DateserialVb Func Datediff β†’