I recently put together a ASP.net website that retrieved data from an SQL table. Even though the regional settings of the server and client machine were set to UK English a date field retrieved from my SQL database keep being displayed in the American format.
I wanted to always display the UK format of (day, month year). This is how to force IIS to use a certain format;
- Open the IIS Manager
- Select either your website or the server if you wish to change all sites
- Select “.Net Globalization”
- Set the “Culture” and “UI Culture” to the desired setting
- Click Apply
- Restart IIS