1. Home
  2. Computing & Technology
  3. Databases

Microsoft Access Function Library: Day()

By Mike Chapple, About.com

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
Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases
  4. Microsoft Access
  5. Access Function Library
  6. Microsoft Access Function Library: Day()>

©2009 About.com, a part of The New York Times Company.

All rights reserved.