w3schools    w3Schools
Search :
   
HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...   References Examples Forum About
ADVERTISEMENTS

XML Certification
Download XML editor
Custom Programming
 
Table of contents
VBScript Tutorial
VB HOME
VB Introduction
VB How to
VB Where to
VB Variables
VB Procedures
VB Conditional
VB Looping
VB Summary

Examples
VB Examples

References
VB Functions
VB Keywords

Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality

Browse Tutorials
 

VBScript DatePart Function


VBScript Reference Complete VBScript Reference

The DatePart function returns the specified part of a given date.

Syntax

DatePart(interval,date[,firstdayofweek[,firstweekofyear]])

Parameter Description
interval Required. The interval of time to return.

Can take the following values:

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of year
  • d - Day
  • w - Weekday
  • ww - Week of year
  • h - Hour
  • n - Minute
  • s - Second
date Required. Date expression to evaluate
firstdayofweek Optional. Specifies the day of the week.

Can take the following values:

  • 0 = vbUseSystemDayOfWeek - Use National 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 - Use National Language Support (NLS) API setting
  • 1 = vbFirstJan1 - Start with the week in which January 1 occurs (default)
  • 2 = vbFirstFourDays - Start with the week that has at least four days in the new year
  • 3 = vbFirstFullWeek - Start with the first full week of the new year

Example 1

document.write(Date & "<br />")
document.write(DatePart("d",Date))
Output:
1/14/2002
14

Example 2

document.write(Date & "<br />")
document.write(DatePart("w",Date))
Output:
1/14/2002
2


VBScript Reference Complete VBScript Reference