Supported SET_LOCALE modifiers in Airtable
  • 18 Dec 2023
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Supported SET_LOCALE modifiers in Airtable

  • Dark
    Light
  • PDF

Article Summary

This article covers using the SET_LOCALE function to streamline your team's and organization's work.

Introduction 

Plan availability

All plan types 

Platform(s)

Web/Browser, Mac app, and Windows app 

Related reading

Supported SET_LOCALE modifiers

Supported SET_LOCALE modifiers overivew

The SET_LOCALE function takes a given datetime input and returns that datetime formatted to match a particular locale. This function is written in the form SET_LOCALE(datetime, 'locale modifier'), in which the locale modifier can be something like 'en-nz' (New Zealand English), 'tzm' (Amazigh/Berber), or 'zh-tw' (Traditional Chinese).

Locale modifiers can change a number of different aspects of a datetime, including:

  • Numerical digits: for certain locales not using West Arabic numerical digits, numerical digits will be converted, e.g. for 'ar' (Arabic), 1 => ٢.

  • Script directionality: for locales using scripts that are written right-to-left, e.g. 'he' (Hebrew), the datetime will change direction accordingly.

  • Month and weekday names : month/weekday names will be changed to reflect the locale's language, e.g. for 'es' (Spanish), Wednesday => Miércoles.

  • Long date format : Long datetimes will be formatted according to the preferred format of the locale, e.g. for 'en-gb' (British English), 'MMMM D, YYYY h:mm A' => 'D MMMM YYYY HH:mm'.

Supported SET_LOCALE modifiers

NOTE

The following is a table of the supported locale modifiers. The examples here use the DATETIME_FORMAT function to better show what each locale modifier does; please see this support article for an explanation of the DATETIME_FORMAT function and this support article for an explanation of the format specifiers used in the DATETIME_FORMAT function.

Locale modifier

Description

Example(s)

af

Afrikaans

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'af'), 'LLLL')

=> Woensdag, 8 Junie 2016 20:22

ar-ma

Moroccan Arabic

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ar-ma'), 'LLLL')

=> الأربعاء 8 يونيو 2016 20:22

ar-sa

Arabic (Saudi Arabia)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ar-sa'), 'LLLL')

=> الأربعاء ٨ يونيو ٢٠١٦ ٢٠:٢٢

ar-tn

Tunisian Arabic

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ar-tn'), 'LLLL')

=> الأربعاء 8 جوان 2016 20:22

ar

Arabic

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ar'), 'LLLL')

=> الأربعاء ٨ حزيران يونيو ٢٠١٦ ٢٠:٢٢

az

Azerbaijani

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'az'), 'LLLL')

=> Çərşənbə, 8 iyun 2016 20:22

be

Belarusian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'be'), 'LLLL')

=> серада, 8 чэрвеня 2016 г., 20:22

bg

Bulgarian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'bg'), 'LLLL')

=> сряда, 8 юни 2016 20:22

bn

Bengali

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'bn'), 'LLLL')

=> বুধবার, ৮ জুন ২০১৬, রাত ৮:২২ সময়

bo

Tibetan

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'bo'), 'LLLL')

=> གཟའ་ལྷག་པ་, ༨ ཟླ་བ་དྲུག་པ ༢༠༡༦, མཚན་མོ ༨:༢༢

br

Breton

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'br'), 'LLLL')

=> Merc'her, 8 a viz Mezheven 2016 8e22 PM

bs

Bosnian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'bs'), 'LLLL')

=> srijeda, 8. juni 2016 20:22

ca

Catalan

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ca'), 'LLLL')

=> dimecres 8 juny 2016 20:22

cs

Czech

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'cs'), 'LLLL')

=> středa 8. červen 2016 20:22

cv

Chuvash

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'cv'), 'LLLL')

=> юнкун, 2016 ҫулхи ҫӗртме уйӑхӗн 8-мӗшӗ, 20:22

cy

Welsh

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'cy'), 'LLLL')

=> Dydd Mercher, 8 Mehefin 2016 20:22

da

Danish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'da'), 'LLLL')

=> onsdag d. 8. juni 2016 20:22

de-at

Austrian German

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'de-at'), 'LLLL')

=> Dienstag, 12. Jänner 2016 18:48

de

German

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'de'), 'LLLL')

=> Dienstag, 12. Januar 2016 18:48

el

Modern Greek

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'el'), 'LLLL')

=> Τετάρτη, 8 Ιουνίου 2016 8:22 ΜΜ

en-au

Australian English

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'en-au'), 'LLL')

=> 8 June 2016 8:22 PM

en-ca

Canadian English

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'en-ca'), 'LLL')

=> 8 June, 2016 8:22 PM

en-gb

British English

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'en-gb'), 'LLL')

=> 8 June 2016 20:22

en-ie

Irish English

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'en-ie'), 'LLL')

=> June 8, 2016 8:22 PM

en-nz

New Zealand English

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'en-nz'), 'LLL')

=> June 8, 2016 8:22 PM

eo

Esperanto

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'eo'), 'LLLL')

=> Merkredo, la 8-an de junio, 2016 20:22

es

Spanish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'es'), 'LLLL')

=> Miércoles, 8 de Junio de 2016 20:22

et

Estonian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'et'), 'LLLL')

=> kolmapäev, 8. juuni 2016 20:22

eu

Euskara (Basque)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'eu'), 'LLLL')

=> asteazkena, 2016ko ekainaren 8a 20:22

fa

Persian (Farsi)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fa'), 'LLLL')

=> چهارشنبه، ۸ ژوئن ۲۰۱۶ ۲۰:۲۲

fi

Finnish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fi'), 'LLLL')

=> keskiviikko, 8. kesäkuuta 2016, klo 20.22

fo

Faroese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fo'), 'LLLL')

=> mikudagur 8. juni, 2016 20:22

fr-ca

Canadian French

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fr-ca'), 'LLLL')

=> mercredi 8 juin 2016 20:22

fr-ch

Swiss French

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fr-ch'), 'LLLL')

=> mercredi 8 juin 2016 20:22

fr

French

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fr'), 'LLLL')

=> mercredi 8 juin 2016 20:22

fy

Frisian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'fy'), 'LLLL')

=> woansdei 8 juny 2016 20:22

gl

Galician

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'gl'), 'LLLL')

=> Mércores 8 Xuño 2016 20:22

he

Hebrew

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'he'), 'LLLL')

=> רביעי, 8 ביוני 2016 20:22

hi

Hindi

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'hi'), 'LLLL')

=> बुधवार, ८ जून २०१६, रात ८:२२ बजे

hr

Hrvatski (Croatian)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'hr'), 'LLLL')

=> 2016. június 8., szerda 20:22

hu

Hungarian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'hu'), 'LLLL')

=> 2016. június 8., szerda 20:22

hy-am

Armenian (Hayeren)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'hy-am'), 'LLLL')

=> չորեքշաբթի, 8 հունիսի 2016 թ., 20:22

id

Bahasa Indonesia (Indonesian)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'id'), 'LLLL')

=> Rabu, 8 Juni 2016 pukul 20.22

is

Icelandic

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'is'), 'LLLL')

=> miðvikudagur, 8. júní 2016 kl. 20:22

it

Italian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'it'), 'LLLL')

=> Mercoledì, 8 giugno 2016 20:22

ja

Japanese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ja'), 'LLLL')

=> 2016年6月8日午後8時22分 水曜日

jv

Boso Jowo (Javanese)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'jv'), 'LLLL')

=> Rebu, 8 Juni 2016 pukul 20.22

ka

Georgian (Kartuli)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ka'), 'LLLL')

=> ოთხშაბათი, 8 ივნისი 2016 8:22 PM

km

Khmer

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'km'), 'LLLL')

=> ពុធ, 8 មិថុនា 2016 20:22

ko

Korean

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ko'), 'LLLL')

=> 2016년 6월 8일 수요일 오후 8시 22분

lb

Luxembourgish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'lb'), 'LLLL')

=> Mëttwoch, 8. Juni 2016 20:22 Auer

lt

Lithuanian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'lt'), 'LLLL')

=> 2016 m. birželis 8 d., trečiadienis, 20:22 val.

lv

Latvian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'lv'), 'LLLL')

=> 2016. gada 8. jūnijs, trešdiena, 20:22

me

Montenegrin

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'me'), 'LLLL')

=> srijeda, 8. jun 2016 20:22

mk

Macedonian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'mk'), 'LLLL')

=> среда, 8 јуни 2016 20:22

ml

Malayalam (Kairali)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ml'), 'LLLL')

=> ബുധനാഴ്ച, 8 ജൂൺ 2016, രാത്രി 8:22 -നു

mr

Marathi

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'mr'), 'LLLL')

=> बुधवार, ८ जून २०१६, रात्री ८:२२ वाजता

ms

Bahasa Malaysia (Standard Malay)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ms'), 'LLLL')

=> Rabu, 8 Jun 2016 pukul 20.22

my

Burmese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'my'), 'LLLL')

=> ဗုဒ္ဓဟူး ၈ ဇွန် ၂၀၁၆ ၂၀:၂၂

nb

Norwegian Bokmål

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'nb'), 'LLLL')

=> onsdag 8. juni 2016 kl. 20.22

ne

Nepali

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ne'), 'LLLL')

=> बुधबार, ८ जुन २०१६, रातीको ८:२२ बजे

nl

Dutch

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'nl'), 'LLLL')

=> woensdag 8 juni 2016 20:22

nn

Norwegian Nynorsk

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'nn'), 'LLLL')

=> onsdag 8 juni 2016 20:22

pl

Polish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'pl'), 'LLLL')

=> środa, 8 czerwca 2016 20:22

pt-br

Brazilian Portuguese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'pt-br'), 'LLLL')

=> Quarta-Feira, 8 de Junho de 2016 às 20:22

pt

Portuguese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'pt'), 'LLLL')

=> Quarta-Feira, 8 de Junho de 2016 20:22

ro

Romanian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ro'), 'LLLL')

=> miercuri, 8 iunie 2016 20:22

ru

Russian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ru'), 'LLLL')

=> среда, 8 июня 2016 г., 20:22

si

Sinhala (Sinhalese)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'si'), 'LLLL')

=> 2016 ජූනි 8 වැනි බදාදා, ප.ව. 8:22:02

sk

Slovak

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'sk'), 'LLLL')

=> streda 8. jún 2016 20:22

sl

Slovenian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'sl'), 'LLLL')

=> sreda, 8. junij 2016 20:22

sq

Albanian (Shqip)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'sq'), 'LLLL')

=> E Mërkurë, 8 Qershor 2016 20:22

sr-cyrl

Serbian Cyrillic

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'sr-cyrl'), 'LLLL')

=> среда, 8. јун 2016 20:22

sr

Serbian Latin

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'sr'), 'LLLL')

=> sreda, 8. jun 2016 20:22

sv

Swedish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'sv'), 'LLLL')

=> onsdag 8 juni 2016 20:22

ta

Tamil

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'ta'), 'LLLL')

=> புதன்கிழமை, 8 ஜூன் 2016, 20:22

th

Thai

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'th'), 'LLLL')

=> วันพุธที่ 8 มิถุนายน 2016 เวลา 20 นาฬิกา 22 นาที

tl-ph

Tagalog/Filipino

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'tl-ph'), 'LLLL')

=> Miyerkules, Hunyo 08, 2016 20:22

tr

Turkish

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'tr'), 'LLLL')

=> Çarşamba, 8 Haziran 2016 20:22

tzl

Talossan

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'tzl'), 'LLLL')

=> Márcuri, li 8. Gün dallas 2016 20.22

tzm-latn

Morocco Central Atlas Tamaziɣt (Amazigh/Berber) in Latin

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'tzm-latn'), 'LLLL')

=> akras 8 ywnyw 2016 20:22

tzm

Morocco Central Atlas Tamaziɣt (Amazigh/Berber)

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'tzm'), 'LLLL')

=> ⴰⴽⵔⴰⵙ 8 ⵢⵓⵏⵢⵓ 2016 20:22

uk

Ukrainian

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'uk'), 'LLLL')

=> середа, 8 червня 2016 р., 20:22

uz

Uzbek

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'uz'), 'LLLL')

=> 8 июнь 2016, Чоршанба 20:22

vi

Vietnamese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'vi'), 'LLLL')

=> thứ tư, 8 tháng 6 năm 2016 20:22

zh-cn

Simplified Chinese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'zh-cn'), 'LLLL')

=> 2016年6月8日星期三晚上8点22分

zh-tw

Traditional Chinese

DATETIME_FORMAT(SET_LOCALE({Date Field}, 'zh-tw'), 'LLLL')

=> 2016年6月8日星期三晚上8點22分


Was this article helpful?