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 €123 456,79 ¥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 13:45 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.
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.