DAY

Retrieves the day of the month from a given date or datetime

Description	The DAY function extracts and returns the day of the month from a given date or datetime. This is useful for analyzing date-based data or creating date-related reports.
Syntax	DAY(date)

1. date: The date or datetime from which you want to extract the day of the month.

Example

Table

Transaction	Sale Date
Transaction A	2023-09-10
Transaction B	2023-08-25
Transaction C	2023-09-01

Function

DAY(`Sale Date`)

Results

DAY (integer)
10
25
1