Skip to main content

Global Default Date

The global default date to use for timelines. Please note that this value does not override the RowEffectiveFromDate.

The value is the solution's beginning-of-time date. In generated Point-In-Time tables it is used as the SQL Default for the timeline date column when that system column has no default of its own defined in Configurations, and the generated Point-In-Time and current-view procedures use it as the from-date when selecting the current timeline. A blank value falls back to 0001-01-01, and the value is passed through the target platform's date conversion in generated SQL.

When to Change This Setting​

Keep the default 0001-01-01 unless your warehouse standard uses a different low date (for example 1900-01-01). The value must be a date in yyyy-MM-dd form. As noted above, a default defined on the RowEffectiveFromDate configuration takes precedence: this setting only fills in where no configuration default is defined.

Notes​

  • This setting is part of the Core settings category.
  • The default value for this setting is 0001-01-01.