--- title: "Supported SET_LOCALE Locale Modifiers | Airtable Support" slug: "supported-locale-modifiers-for-set-locale" description: "This article covers using the SET_LOCALE function to streamline your team's and organization's work." updated: 2025-04-28T22:17:38Z published: 2025-04-28T22:17:38Z --- > ## Documentation Index > Fetch the complete documentation index at: https://support.airtable.com/llms.txt > Use this file to discover all available pages before exploring further. # Supported SET_LOCALE modifiers in Airtable | **Plan Availability** | All plan types | | --- | --- | | **Permissions** | - **Owner** / **Creator** - Can add, delete, duplicate, rename, and customize fields - **Editors** - Sort, filter, group, hide, and copy field URL - **Commenters / Read-only** - Copy field URL | | **Platform(s)** | Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) | ## Supported SET_LOCALE modifiers overview The SET_LOCALE function allows you to include a given datetime input and return that datetime formatted to match a selected 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.' ## FAQs **What parts of datetime can local modifiers impact?** - **Numerical digits**: Certain locales not using West Arabic numerical digits, numerical digits will be converted, e.g. for 'ar' (Arabic), 1 => ٢. - **Script directionality**: 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** The following is a table of the supported locale modifiers, with examples using the [DATETIME_FORMAT function](/docs/formulas-and-date-fields) to display what each locale modifier does. | **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分 |