DAY

Description

Returns the day of the month from a Date or Datetime in the context user's local time zone.

Syntax

DAY(date/datetime) -> Integer

Parameters

ParameterData TypeRequiredDescription
date/datetimeDate/DatetimeYesThe Date or Datetime value from which to extract the day.

Example

DAY(DATE(2024, 1, 25))
-- Returns 25.

Related Formula