You are here:About>Computing & Technology>Databases> Microsoft Access> Access Function Library> Microsoft Access Function Library: Day()
About.comDatabases
Newsletters & RSSEmail to a friendSubmit to Digg

Microsoft Access Function Library: Day()

From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!
Function: Day()

Purpose: The Day() function returns an integer corresponding to the day of the month (1-31) corresponding to the input date.

Usage: Day(date_expression)

The input date_expression is usually a string value or date invariant, but can be any expression that evaluates to a date in the range January 1, 100 through December 31, 9999.

Returns: Integer corresponding to the day of the month of date_expression.

Examples and Special Cases
Day(“February 1, 2006”) returns 1
Day(“2/12/2006”) returns 12
 All Topics | Email Article | | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.