Multi-culture support for formatting numbers and date/time

We’ve extended Format function with additional “culture” parameter which allow you to format number, date, time and timestamp to a particular culture.

Format(number, “pattern”, “unit”, “culture”)

Format(123456.789, “C”, “$”, “en-US”)
Format(123456.789, “C”, “€”, “fr-FR”)
Format(123456.789, “C”, “¥”, “ja-JP”)
€123 456,79

Format(date, “pattern”, “culture”)

Format(#2009-06-15#, “D”, “en-US”)
Format(#2009-06-15#, “D”, “es-ES”)
Format(#2009-06-15#, “D”, “el-GR”)
Monday, June 15, 2009
lunes, 15 de junio de 2009
Δευτέρα, 15 Ιουνίου 2009

Format(time, “pattern”, “culture”)

Format(#13:45:30#, “t”, “en-US”)
Format(#13:45:30#, “t”, “hr-HR”)
Format(#13:45:30#, “t”, “ar-EG”)
1:45 PM
01:45 م

Format(timestamp, “pattern”, “culture”)

Format(#2009-06-15 13:45:30#, “G”, “en-US”)
Format(#2009-06-15 13:45:30#, “G”, “da-DK”)
Format(#2009-06-15 13:45:30#, “G”, “zh-CN”)
6/15/2009 4:45:30 PM
15-06-2009 16:45:30
2009/6/15 16:45:30

Please review additional format patterns and supported cultures.

Tweet about this on TwitterShare on Facebook2Share on Google+1

One thought on “Multi-culture support for formatting numbers and date/time

  1. Fantastic, thanks! It would be great if we could also select this formatting on default date or timestamp fields. You can select “short date and time”, “long date and time” etc, but it would be even better if you could select the locale from a dropdown. But, it’s really nice to be able to use a formula text to redefine the display of a timestamp etc in this way.

Comments are closed.