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: [email protected] 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
