Join Log in
Score:1
Daniel avatar Server

Date format inconsistency with IIS on different servers

bn flag
Daniel

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.

137
0 + 2
iis
cn flag
Greg Askew
I'm inclined to think this could be the app. Unless there is something in machine.config. And this is still a bit murky, as it seems it could be the text as rendered from the server within an element has the wrong format, or some other type of more complex date control is rendering wrong on the client. Also, non-ui culture, unless this is a commercial app that is going to customers, should be hard-coded in the app, not in the config file. This is because even something benign like calling DateTime.ToString() can throw an exception if the culture is set to an unexpected value.
1
Reply
Daniel avatar
bn flag
Daniel
Thanks for the input @GregAskew dynamically setting the culture hadn't been a material issue in the past, given similarities in culture for our users, but it seems it's something we need to address.
0
Reply
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.