Logo Docs
Logo Docs

DAY

Returns the day of the month for a given date as a number

Usage

DAY(date)

Parameters

date

(Required) The date from which to extract the day

Examples

Example With these variables Result

DAY(event_date)
event_date is DATE(2024, 5, 28)

28

DAY(DATE(2024, 1, 12))

 (None)

12

Reminders

A text containing a date is not handled as a date. To have an actual date:

  • use the @DATE_QUESTION to set the variable
  • use a function that converts to a date: DATEVALUE(text_date)
  • use a function that returns a date: TODAY() or DATE(year, month, day)

See also