QFind anything/
API Reference

Locale Preferences

Locale, timezone, currency, and date/number format. Used by field mappings and parsing.

What are locale preferences

Locale preferences control how numbers and dates are parsed and formatted. They are part of TenantSetting.localePreferences and are used by:

  • Field mappings — Transforms like parseLocaleNumber, parseDate use these settings
  • Number parsing — Decimal separators (. vs ,), thousands separators
  • Date formatting — Display and parsing of dates

Configure locale preferences when your data uses non-US formats (e.g. European 1.234,56 or dd.MM.yyyy).

When to configure

  • Stripe/CSV from EU — Set locale: de-DE, dateFormatPref: european, numberFormat: de-DE
  • Multi-currency — Set currencyCode to match your primary currency
  • Timezone — Set timezone for correct date handling (e.g. Europe/Zurich)

Attributes

AttributePurpose
localeBCP 47 (e.g. en-US, de-DE)
timezoneIANA (e.g. America/New_York)
currencyCodeISO 4217 (USD, EUR)
dateFormatPrefiso, european, or us
numberFormate.g. en-US, de-DE

Defaults

When not set: locale: en-US, timezone: UTC, currencyCode: USD, dateFormatPref: us, numberFormat: en-US.