Application control over date input and output formats

[nhcohen]

By default, the format in which a date is displayed, and input into forms, is determined by the locale of the user's device. My application will be used in a locale where the dd/mm/yyyy format is in common use, but many of the users will be ex-pat Americans accustomed to the mm/dd/yyyy format.

To reduce the opportunity for error, I would like to use the yyyy-mm-dd format, both in displayed data and in input fields. How can I accomplish this?

[James_Burns]

Perhaps a virtual column using the TEXT() function.

TEXT([date],"yyyy-MM-dd")

Edited to add: this will only help with the display part. I don't know of a way to force the input field into that format with the user changing their device locale settings as Steve suggests.

[Steve]

Have the users change their device's locale?