Good morning,
Apologies for the newbie question. I'm just getting started with ASP.NET internationalization settings.
Background info:
I have a website which displays a <table>
HTML object. In that <table>
HTML object, I have a column which displays dates. My server being in the US, those dates show up as MM/DD/YYYY
. Many of my users plug into this webpage through Excel, via the Data --> Import External Data --> Import Web Query interface. My users, for the most part, are in the US, so those dates show up correctly in their Excel screens.
Now I need to make the webpage work for UK users. As is, they are downloading the dates as MM/DD/YYYY
, which makes their spreadsheets unusable since their regional settings are set to DD/MM/YYYY
.
My question is:
How do I make it so the web server realizes that the incoming request has a en-GB
culture setting? I could engineer my own little custom workaround, but I'm sure I'm not the first programmer to come across this. How do the pro's handle this? I'm looking for a solution that would be relatively simple and quick to put up, but I don't want to just put some crappy buggy piece of my own logic togethe that I'm going to dread 6 months from now.
Thanks a lot in advance, -Alan.