DATE_EXTRACT

In Project variables

DATE_EXTRACT works only in dynamic project variables, not in node formulas.

The DATE_EXTRACT function extracts the year, quarter, month, week, or day from a given time level value.

Use this function in dynamic project variables when you need to derive one time level value from another (for example, the forecast year from the forecast start month): DATE_EXTRACT("$FORECAST_START", "Year").

Parameters

TimeLevelValueLevel valueRequired

A value of any time level in the project’s time dimension, given as a quoted string or as a variable reference (for example "2026-01" or "$FORECAST_START").

TimeLevelLevel nameRequired

The time level whose value should be returned. Allowed values: "Year", "Quarter", "Month", "Week", "Day".

Output shape

Return type

Level value

Format

Format of the chosen TimeLevel

Watch out

Examples

Extract the year from a month

Formula: DATE_EXTRACT("2026-06", "Year")

Extract the quarter from a day

Formula: DATE_EXTRACT("20260515", "Quarter")

Derive a value from another variable

If a project has a fixed variable $FORECAST_START = "2026-04", you can define a derived variable FORECAST_YEAR as:

Formula: DATE_EXTRACT("$FORECAST_START", "Year")

The derived variable updates automatically whenever $FORECAST_START is changed.

Step from a coarser to a finer level

"2026" is a year. When you ask for a finer level (Quarter, Month, Week, or Day), the function returns the first value at that level.

Extract the quarter of the forecast end

To compute the quarter that the forecast end falls in, first offset the forecast start by 12 months with DATE_OFFSET, then extract the quarter.

If $FORECAST_START = "2026-04":

Formula: DATE_EXTRACT(DATE_OFFSET("$FORECAST_START", "Month", 12), "Quarter")

The combined result is "2027-Q2".

See also

DATE_OFFSET

When you want to offset a value forward or backward rather than return it at a different time level.