Locale support for built in functions?

Locale support for built in functions?

  

In a multi-lingual application and with my locale set to French (Canada) fr-CA the built in data formatting function is returning the english for the Month.


Are the built in functions that return text, such as FormatDateTime, supposed to return the textual parts (such as Month MMMM) in the language of the Locale or do they always return English?


i.e. Is there something I am not doing or do I have to code my own logic to translate the textual parts to the locale in use?

Hi Keith,

FormatDateTime built-in does not respect current locale (unfortunately). You'll have to do your own logic.

Thanks for letting me know. Seems like a bit of a miss, but I guess it is what it is.