Date format of Query Parameters
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7389
Printed Date: 05 May 2024 at 7:28am
Topic: Date format of Query Parameters
Posted By: Taha
Subject: Date format of Query Parameters
Date Posted: 16 Aug 2009 at 4:26am
|
in Short: Where can I modify the date format in the "enter query parameter values" screen 
In more details: I am using Crystal Reports connector for Documentum. Documentum stores in it's DB the dates in the same format as the Regional Settings of the server it is running on (in this case mm/dd/yyyy) While building the report on Crystal Designer XI, I build the query in this way SELECT count (*) from tsp_doc where execution_date between {?start_date} and {?end_date} Where start and end_date are parameters of type date. 
(notice that the default value that is set for me is in the right format (mm/dd/yyyy) ) Altough I did set in Designer Options the date format to dd/mm/yyyy 
I am still prompted to enter the date format in yyyy-mm-dd in this "enter Parameters value" pop-up. (first screenshot on top) I MUST change THIS format to mm/dd/yyyy. any idea how to do this would be infinitely appreciated. Kind Regards, Taha |
Replies:
Posted By: Taha
Date Posted: 19 Aug 2009 at 11:44pm
|
Any ideas ? It would be really weird / stupid to hardcode the date format and force report designers / users to convert it to yyyy/mm/dd and back before being able to use it.... Any help would be much appreciated here. T. |