MONTH

Returns the month portion of the specified date value.

Syntax

MONTH(dateval)

Example

If mydatefield has value '2024-10-30 09:55:00', then:

MONTH({{mydatefield}})

returns: 10

Related

YEAR
DAY
HOUR
MINUTE
SECOND