Date formatting - Incorrect Locale

[EdwinChua]

I have a form field, which is autopopulated by the variable 'd1', which is initialized this way:

Set(d1,Text( Today(), "[$-en-US]dd mmm yyyy"));

In most cases, this works nicely, and when the form is submitted (a sharepoint list item is created), I get "28 May 2020" in the date column.

However, I noticed that some users set their locale (or something), which messes with this, and instead I end up with "02 6月 2020".  This field is not visible to the user.

Questions:

1. Is this the expected behaviour of the Text() function?

• I had expected that specifying [$-en-US] would have standardized the formatting.

2. Is there anyway to ensure I get the date like this ("28 May 2020") regardless of the user's locale settings?

[timl · Accepted solution]

Hi @EdwinChua 

This should produce the correct output for you.

Set(d1,Text( Today(), "[$-en-US]dd mmm yyyy", "en-US"));

The third argument defines the output locale.

The [$-en-US]  part of this defines the locale of your format string.