Changing the Date to en-US culture irrespective of the local culture

[Aruna Mohan]

Hi,
The issue is in a windows based client-server application.In the GUI, the system date value is converted to string and is stored in a text box, which is displayed while the dialog gets loaded.
How to change the format of date so that when the form loads the date is displayed in en-US culture irrespective of the regional setting of the system(for eg: regional setting of the system is "fr-FR").

[kadghar]

store it as a DATE, even if you read it from a text field, you can check if it can be stored as a DATE with ISDATE function.

Once it's a date field, you can easily show it in any format you want to.