Search…
Resources
Related Links
day
To return the day of the month from a given 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 1')
Result: 1 (with Date1 = 07/01/2021) (US) and Date 1 = 01/07/2021 (UK))
day(myTimestamp) To return the day of the month of a given timestamp.
day(1624226400000)
Result: 21 (of June 21, 2021)

‌See also

month, which returns the month from a 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.
Last modified 2mo ago
Export as PDF
Copy link