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

    Supported SET_LOCALE modifiers in Airtable

    • Dark
    • 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?