month() is a helper routine that simplifies the creation of an oft-used SQL statement to obtain just the month of a specified date/time field as a 2 digit number (MM). If the value of the month is less than 10, it is zero padded. This allows for correct sorting.
The date/time fieldname to be processed
In the following example, we analyze the most often occurring month of the year for a birth date