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