Local-based full-year date display in Designer reports

Designer reports support a locale-based full-year format for dates. This format displays the year as four digits (YYYY) and maintains the locale-specific date order.
Locale-based formatting is preserved:
  • Europe: DD/MM/YYYY
  • US: MM/DD/YYYY

The underlying data type remains Date.

The format removes ambiguity for future years by showing the complete year.

Example:
  • Previous display: 31/12/32 may be misread as 1932.
  • New display: 31/12/2032 shows the correct year without any ambiguity.