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
isNull
,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 ofdateexpression
is 2/29 for a non-leap year.To return the day of the week, use the
WeekDay
function.
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.