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.
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.
- Date = 07/01/2021) (US)
- Date = 01/07/2021 (UK))
day(myTimestamp)To return the day of the month of a given timestamp.
Result: 20 (of June 20, 2021)