DAY

Use the DAY function to return the day-of-month from a Date or Date/Time. The day is given as a number ranging from 1 to 31.

Use

DAY( date )
Return the day of the month from a date as an integer between 1 and 31.

Parameter	Required	Description
date	Yes	the date to extract the day of month from

Returns

Number

Use with literals

DAY(DATE(2024, 1, 31))

returns 31

Use with fields

DAY(@CompleteDetails.out.DOB)

if field @CompleteDetails.out.DOB is 27/02/1996, returns 27