Skip to main content
Returns an integer representing the month component in a specified datetime value. Category: date Syntax: 
Month([date_column])
Returns: IntColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
date_columncolumn|datetime✓ YesThe date to extract month from.
Allowed Column Types: DATETIME, DATE

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Month([OrderDate])
Returns month (1-12) from date.
Last modified on March 13, 2026