Name
Day Function
Class
Microsoft.VisualBasic.DateAndTime
Syntax
Day(datevalue)-
datevalue(required; Date or literal date)
Return Value
An Integer from 1 to 31, representing the day of the month
Description
Returns an Integer ranging from 1 to 31, representing the day of the
month of datevalue
Rules at a Glance
The range of datevalue is 1/1/1 to
12/31/9999.
Programming Tips and Gotchas
When working with dates, always check that a date is valid using the IsDate function prior to passing it as a function parameter.
With
OptionStrictOn, you must first convertdatevalueto a Date data type before passing it to the Day function. You can use the CDate function for this purpose.If the day portion of
datevalueis outside of its valid range, the function regenerates runtime error 13, “Type mismatch.” This is also true if the day and month portion ofdatevalueis 2/29 for a non-leap year.To return the day of the week, use the WeekDay function.