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?
2. Is there anyway to ensure I get the date like this ("28 May 2020") regardless of the user's locale settings?
Solved! Go to 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.
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.
User | Count |
---|---|
183 | |
110 | |
88 | |
44 | |
42 |
User | Count |
---|---|
227 | |
108 | |
106 | |
68 | |
68 |