DAY

Returns the day of the month value of a DateTime.

Syntax

int? DAY(DateTime? value)

Example

DAY(TODAY())

Will return the day value of today's date e.g. 28 or 2.

Alternatively you can use a DateTime column from your data source for example OrderDate:

DAY(OrderDate)