VBScript in a Nutshell

Name

Day Function

Syntax

Day(dateexpression)

dateexpression

Use: Required

Data Subtype: Any valid date expression

Any expression capable of conversion to a Date.

Return Value

Variant of subtype Integer.

Description

Returns a variant integer data subtype that can take on a value ranging from 1 to 31, representing the day of the month of dateexpression. dateexpression, the argument passed to the Day function, must be a valid date/time or time value.

Rules at a Glance

• dateexpression can be any variant, numeric expression, or string expression that represents a valid date.

• The range of dateexpression is 1/1/0000 to 12/31/9999.

• If dateexpression is Null, Null is returned.

Programming Tips & Gotchas

• When working with dates, always check that a date is valid using the IsDate function prior to passing it as a function parameter.

• If dateexpression omits the year, Day still returns a valid day.

• If the day portion of dateexpression is outside its valid range, the function generates runtime error 13, “Type mismatch.” This is also true if the day and month portion of dateexpression is 2/29 for a non-leap year.

• To return the day of the week, use the WeekDay function.

See Also

DatePart Function, Weekday Function, WeekdayName Function , Month Function, Year Function