VBScript DatePartFunction


VBScript 参考手册Complete VBScript Reference

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

Syntax

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

Parameters 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 evaluate.
firstdayofweek Optional. Specifies the first 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 falls (default)
  • 2 = vbFirstFourDays - Start with the first week that has at least four days in the new year
  • 3 = vbFirstFullWeek - Start with the first full week of the new year

Examples

Example 1

Get the month from a date:

<script type="text/vbscript">

d=CDate("2010-02-16")
document.write(DatePart("m",d))

</script>

Output of the above example:

2

Try it Yourself »

Example 2

Get the month we are currently in:

<script type="text/vbscript">

document.write(DatePart("m",Now()))

</script>

Output of the above example:

document.write(DatePart("m",Now()))

Try it Yourself »

Example 3

Get the hour:

<script type="text/vbscript">

document.write(DatePart("h",Now())

</script>

Output of the above example:

document.write(DatePart("h",Now()))

Try it Yourself »


VBScript 参考手册Complete VBScript Reference Other Extensions