In Crystal, check File --> options --> Fields --> Date --> Date Tab and see what's specified.
HTH Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] "sanapala, Rajinikanth IN BOM SISL" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 02/07/2008 08:22 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [ARSLIST] Crystal Reports Date problem. ** Hello, I checked the window settings (regional) they are in English US and Date format is MM/DD/YY and user tool is in En US. Still I am facing the same problem. Can any one suggest me how to deal this? ARS: 6.3 Oracle 9i Crystal Report 10 Regards, Rajinikanth From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Thursday, February 07, 2008 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Date problem. What date format do you have set in Windows (Control Panel >> Regional and Language Options)? I believe the client will use these settings by default. You should be able to set a different date format for the client under Tools >> Options >> Locale. HTH, Thomas ----- Original Message ----- From: sanapala, Rajinikanth IN BOM SISL Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, February 06, 2008 22:41 Subject: Crystal Reports Date problem. ** Hello ARS List, I have got a strange problem with my reports, I am entering my Date Ranges in Remedy user in (MM/DD/YY, MM/DD/YY), but when it is retrieving the records from the system it is considering as (DD/MM//YY) And some times query engine error. For Ex: I wanted to retrieve (1/2/2007 2nd Jan to 05/06/2007 may 6th ) it is giving the values from 1st Feb. to 5th Jun. What need to be done to come out of this problem. Thanks in Advance. Rajinikanth. SISL INDIA Important notice:This e-mail and any attachment thereto contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Important notice:This e-mail and any attachment thereto contains corporate proprietary information. If you have received it by mistake, please notify us immediately by reply e-mail and delete this e-mail and its attachments from your system. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"