MONTH

Returns just the month element of the date supplied. Any leading zeros will be removed.

MONTH ( <date_field or date> )

• date_field or Date: The date to use in the calculation.

Example: Create a field on the CUSTOMER table that shows just the month portion of a customer's date of birth.

MONTH( [CUSTOMER.DATE OF BIRTH] )