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.
Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.
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] )