day

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")
Was this helpful?
How can we improve it?