Don't worry Jarl, this is far from business rules. This is for display only purposes on display of a record, to tell you how many business hours it's been open. Doing it on display was the 'best' I could come up with....other options involved having an escalation that fired every x to update all open records with their 'current' value...not something I'm interested in doing...so a simple display of the information on screen any time the record is opened works really well....
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jarl Grøneng Sent: Friday, November 13, 2009 10:06 AM To: [email protected] Subject: Re: Date Format - US/UK Hi, You should not doing business rules and logic in Active links! Filters handles this much better :-) As ben mention, moving the business time to filters will probably solve your issue. -- Jarl 2009/11/13 LJ Longwing <[email protected]>: > 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" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

