Both would work though you'd need a server for the second midtier option and just extra records for the user profile option. I personally would opt for the user profile and perhaps some extra workflow to set it if the person's address was the UK (or some other automated way of setting extra records :)) - purely for the ease of not setting up another server.
Also, the option of the AL doing a push fields to a dummy form, having the form to the calculations, and then the AL picking up the result (and deleting the record) would also work. Cheers Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: November 13, 2009 6:20 PM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK I have a table field that does a descending sort on 'Create Date'. This of course shows the most recently created records first. When looking at this table before doing the locale I see records created today at the top of the list '11/13/2009'. When I apply the GB locale and perform the same search, I get ....hmmm...ok...the difference is that the app server I was using locale vs. no-locale didn't have anything created after Oct 30th....never mind on the sorting problem...:) The real question I was asking though was this. 'How to handle this properly'...is setting a locale on a specific users profile the best way, or should I be able to stand up a 'UK' MidTier server and anyone that logs into it gets the proper date format? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Friday, November 13, 2009 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK I have never seen any 'sorting' issues. Perhaps you could provide more detail as to what exactly you are seeing with respect to the 'sorting issues' As for the Business time. The AL formats the date on the "command line" and passes it to the server to perform the Business time calculations. If that AL is running on a UK machine, then the server get's a bad time. 1) can you not do this work in a filter (no issues with date formats) ? You can do something like a push fields from the AL to a form, and on that form a filter to calculate the business time, then the AL does a set field from that lastid record to pick up the calculation. 2) if 1 is not possible or convenient, then you can change your al set to if locale == 'en_GB' (or != us!) copy the date in q to char field, arrange that date into the correct sequence fi Remember that there is no format for a date in the database. All date fields (date, date_only, timeofday) and simple 32 bit integers. Cheers Ben Chernys -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: November 13, 2009 5:18 PM To: arslist@ARSLIST.ORG Subject: Date Format - US/UK 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"