Month / Temporal Layer

Extract month number from date/datetime values, similar to datetime.month in Python or MONTH() in SQL. Returns integers from 1 to 12.

Example extractions:

Date	Month	Name	Quarter	Days
2024-01-15	1	January	Q1	31
2024-02-29	2	February	Q1	29
2024-06-30	6	June	Q2	30
2024-12-31	12	December	Q4	31

Common applications:

Monthly reporting
Seasonal analysis
Financial periods
Resource planning
Growth comparisons

Table

Transforms

[, ...]

Select

column

Date/datetime column to extract month from. Returns calendar month number (1-12), where 1=January through 12=December.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.