day

To return the day of the month from a date value as a number

‌This function extracts the day of a month from a date, appointment, or timestamp; therefore, the result will be a numeric value between 1 and 31.

‌You can use all data types containing a date for the calculation.

Syntax

day(appointment)

day(date)

day(timestamp)

‌Return

‌number

Examples

‌day(myAppointment) To return the day of a given start of an appointment.

‌day(myDate) To return the day of the month of a given date.

day('Date')

‌Result: 1

(with

• Date = 07/01/2021) (US)

• Date = 01/07/2021 (UK))

‌day(myTimestamp) To return the day of the month of a given timestamp.

day(1624226400000)

‌Result: 20 (of June 20, 2021)

‌See also

‌month, which returns the month from a given date value as a number.

quarter, which returns the quarter of a given date value as a number.

week, which returns the calendar week of a given date value.

year, which returns the year of a given date value.