Day

Returns the day of the month (from 1 to 31) for the date entered as a parameter.

Syntax

Day(date)
Jour(date)
date = date for which you want to retrieve the day of the month

Remarks

If you want to retrieve the current day, you can use the Now function as a parameter.

Example

Day(Now()) = if the current day is January 5, 2010, this will return 5
Jour(Now()+1) = tomorrow's day, so on January 31, this will return 1 (for February 1)

Classification

DateTime