Rick - what a fantastic answer! I'm sitting here in the office (it's 8.25am here) and I'm feeling miserable because the weather's beautiful and I'm stuck indoors - your post really did make me laugh out loud!
Thanks for cheering me up. Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: gavin.cole...@computacenter.com W: www.computacenter.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: 24 June 2010 08:21 To: arslist@ARSLIST.ORG Subject: Re: Date/Time Field - Bug Found "Doctor! Doctor! It hurts when I do this!" "Well, then don't do that!" I would suggest that if your users did any number of incorrect things, they would get results they didn't like. This is not a bug, it is a PEBCAK issue. Train your users in the correct format for the Date/Time string, and their results should improve accordingly. ------Original Message------ From: koray Sender: Arslist To: Arslist ReplyTo: Arslist Subject: Date/Time Field - Bug Found Sent: Jun 24, 2010 3:10 AM Hello all, My regional settings for date/time field is as follows: 6/24/2010 9:45:12 AM If I (or the user) enters date/time as "24062010 9:45:12" remedy creates the database entry with integer value of 24062010 - which maps to actually "10/6/1970 2:53:30 PM". Therefore this causes a big unstability and I guess another bug of Remedy ARS. BR, Koray _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" Rick ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"