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