To start off, here are the stats ARS 7.1 P6 (Windows) MidTier 7.1 P6 (Solaris)
I have an app server running on windows, and a Solaris based MidTier server, both US based and non localized. Everything works fine till we bring on UK based people working in the system. They go to enter a date in a field manually and give it '28/11/09' as the date, which of course to them is 'November 28th 2009', but with a US based system, that's the 28th month, 11th day of 2009....strangely Remedy seems to be translating that to April 11th 2011...it seems to be saying oh...28th month...well that's 2 years and 4 months....so...weird. We need to provide the UK based folks with an easy method to provide dates in their format and have the server not puke on the input. My first thought is that if we stand up a MidTier server using regional settings of UK, that it would automatically translate between the client and server, that didn't seem to work the way I was thinking, so I consulted my documentation, and it discussed User preference records. So I configured my user account to have a locale of en_GB, which according to the drop down is 'English (United Kingdom)'. This seemed to do what I needed, everywhere I look dates are in format DD/MM/YYYY, but I noticed two issues. First is that the dates don't seem to be 'sorting' properly and I have an AL that calls the server for business time calculations, and that threw an error saying either start or end time was incorrect.... I've never done anything internationally before and would love some expert help from those that have dealt with this situation before. Any and all suggestions are appreciated. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
