Re: Date Format - US/UK
Dave, That is such a MAJOR undertakingwow... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dave Saville Sent: Thursday, November 19, 2009 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK In a similar mixed shop I found the only safe solution was to hide *all* date fields, make dates display with the month spelt out and use drop down lists for day/month/year and do the conversion under the covers. HTH -- Regards Dave Saville ___ 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"
Re: Date Format - US/UK
In a similar mixed shop I found the only safe solution was to hide *all* date fields, make dates display with the month spelt out and use drop down lists for day/month/year and do the conversion under the covers. HTH -- Regards Dave Saville ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Date Format - US/UK
Possibly. That depends on network latency time etc. But sure, the round trip time "could" be shorter - depending on the real network layer topography. Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: November 13, 2009 6:45 PM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK Isn't it true that setting up an additional UK based MidTier server would give them better overall performance vs. accessing a US based MidTier server? That alone is the only reason I would contemplate setting up another server. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Friday, November 13, 2009 10:33 AM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK 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 30thnever 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 2009strangely 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 monthsso...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 discu
Re: Date Format - US/UK
Hehehe...I was thinking the same thing. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jarl Grøneng Sent: Friday, November 13, 2009 10:42 AM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK > > 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. Is not this the Service action? -- Jarl ___ 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"
Re: Date Format - US/UK
Isn't it true that setting up an additional UK based MidTier server would give them better overall performance vs. accessing a US based MidTier server? That alone is the only reason I would contemplate setting up another server. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Friday, November 13, 2009 10:33 AM To: arslist@ARSLIST.ORG Subject: Re: Date Format - US/UK 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 30thnever 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 2009strangely 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 monthsso...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/, 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
Re: Date Format - US/UK
> > 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. Is not this the Service action? -- Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Date Format - US/UK
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 30thnever 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 2009strangely 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 monthsso...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/, 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...@ver
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 30thnever 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 2009strangely 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 monthsso...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/, 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"
Re: Date Format - US/UK
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 withother 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:arsl...@arslist.org] On Behalf Of Jarl Grøneng Sent: Friday, November 13, 2009 10:06 AM To: arslist@ARSLIST.ORG 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 : > 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 2009strangely 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 monthsso...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/, 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"
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 : > 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 2009strangely 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 monthsso...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/, 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"
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 2009strangely 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 monthsso...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/, 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"
