Returns the 1 or 2-digit day of the month from the specified date. For example, the function returns:
- 1 for January 1, 2012
- 31 for December 31, 2012
Syntax
day(date)
date can be any of the following:
- Another function that returns a date.
- A formula column that returns a date.
Examples
- If today is January 1, 2012 the following function returns 1:
day(today()) - The following function returns 1:
day(date(2013,01,01)) - If c:"specialDay" is a formula column that specifies October 1, 2015, the following function returns 1:
day(c:"specialDay")