We have a few environments for our product: Development, Quality Assurance and Production. When browsing a site hosted on the Dev environment, the date format is yyyy-MM-dd on QA & Prod, it is yyyy/MM/dd. The decimal point on Dev is . while the decimal point on QA & Prod is ,.
I've seen questions like this, this and this that refer to the .NET Globalization at the app-level. In each of our web-applications, the following line exists in the web.config, (Client Based Culture is also set to False):
<globalization culture="en-ZA" uiCulture="en"/>
All three servers also have the same regional settings, the OS-level date format is yyyy-MM-dd and decimal symbol on all three is set to .. How is it that the date formats AND the decimal points differ on the sites only? In the OS, the formats all match each other e.g. in Excel / System Clock.
This is causing problems with automated testing as the asserted values are often incorrect given the format difference. We can adjust our test fixtures but this isn't a solution to the underlying issue.
