DatePart

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

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

Parameters	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 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 - Here 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

To get the month from a date :

dDatePart = CDate("2010-02-16")
dDatePart = (DatePart("m",d))
DEBUG(dDatePart)

Result :

dDatePart
= 2

Example 2

To get the month we are in :

dDatePart = (DatePart("m",Now()))
DEBUG(dDatePart)

Result :

dDatePart
= 2

Example 3

To get the hour :

dDatePart = (DatePart("h",Now())
DEBUG(dDatePart)

Result :

dDatePart
= 9