DAY

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

Updated over a week ago

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)

Output

integer

Variables

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

Example

DAY(`Sale Date`)

Transaction

Sale Date

DAY(`Sale Date`)

Transaction A

September 10, 2023

10

Transaction B

August 25, 2023

25

Transaction C

September 1, 2023

1

Did this answer your question?