Cultures

Some Date Functions have a Culture parameter that can be used to format the date. The different cultures you can use are listed below. Insert the Language Culture Name in the formula.

E.g. dayName(#15/02/2017 12:00#, "it-IT") => "Mercoledì"

Language Culture Name Display Name
af-ZA Afrikaans - South Africa
sq-AL Albanian - Albania
ar-DZ Arabic
hy-AM Armenian - Armenia
Lt-az-AZ Azeri (Latin) - Azerbaijan
eu-ES Basque - Basque
be-BY Belarusian - Belarus
bg-BG Bulgarian - Bulgaria
ca-ES Catalan - Catalan
zh-CN Chinese - China
hr-HR Croatian - Croatia
cs-CZ Czech - Czech Republic
da-DK Danish - Denmark
div-MV Dhivehi - Maldives
nl-BE Dutch - Belgium
nl-NL Dutch - The Netherlands
en-AU English - Australia
en-GB English - United Kingdom
en-US English - United States
et-EE Estonian - Estonia
fo-FO Faroese - Faroe Islands
fa-IR Farsi - Iran
fi-FI Finnish - Finland
fr-FR French - France
de-DE German - Germany
el-GR Greek - Greece
gu-IN Gujarati - India
he-IL Hebrew - Israel
hi-IN Hindi - India
hu-HU Hungarian - Hungary
is-IS Icelandic - Iceland
id-ID Indonesian - Indonesia
it-IT Italian - Italy
it-CH Italian - Switzerland
ja-JP Japanese - Japan
kn-IN Kannada - India
kk-KZ Kazakh - Kazakhstan
kok-IN Konkani - India
ko-KR Korean - Korea
ky-KZ Kyrgyz - Kazakhstan
lv-LV Latvian - Latvia
lt-LT Lithuanian - Lithuania
mk-MK Macedonian (FYROM)
nb-NO Norwegian (Bokmål) - Norway
nn-NO Norwegian (Nynorsk) - Norway
pl-PL Polish - Poland
pt-BR Portuguese - Brazil
pt-PT Portuguese - Portugal
ro-RO Romanian - Romania
ru-RU Russian - Russia
Lt-sr-SP Serbian (Latin) - Serbia
sk-SK Slovak - Slovakia
sl-SI Slovenian - Slovenia
es-ES Spanish - Spain
sw-KE Swahili - Kenya
sv-FI Swedish - Finland
sv-SE Swedish - Sweden
syr-SY Syriac - Syria
tt-RU Tatar - Russia
te-IN Telugu - India
tr-TR Turkish - Turkey
uk-UA Ukrainian - Ukraine
What would you improve in this article?
Powered by:

Type above and the results will be displayed here.