Definition
The DAY() function returns the day of the month (from 1 to 31) for a specified date.
Syntax
DAY(date)
where date is required and it is the date to return the day of the month from.
Example(s)
What to use in Custom SQL field:
DAY(GETDATE())
DAY([Assignment: Actual End Date])
Field Outputs:
